Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL error -908, ISAM error 22?

Status
Not open for further replies.

Vandy02

Programmer
Jan 7, 2003
151
0
0
US
I am running a script the loads data from .dat files int informix...everything worked well a few days ago...but now I receive the error below

========SCRIPT===============

# -- load the tables in the order they were created, no
# --logging, commit not needed

dbload -d maximo -c craftcodes.ctl -l craftcodes.log -e 100
dbload -d maximo -c eqstatus.ctl -l eqstatus.log -e 100
sleep 2
onpload -j employee_ld -fl
sleep 2
onpload -j locations_ld -fl
sleep 2
onpload -j equipment_ld -fl
sleep 2
onpload -j wosummary_ld -fl
sleep 2
onpload -j pm_ld -fl
# added 7/15/02
#
dbaccess maximo <<-eof
SET PDQPRIORITY 80;
DELETE FROM pmdetail WHERE substr(pmnum,1,1) = ' ' or pmnum is null;
eof

onpload -j jobplan_ld -fl
sleep 2
onpload -j fleet_ld -fl
sleep 2
onpload -j invoice_ld -fl


===========ERROR=============
62900 Row(s) loaded so far to table maximo_eqstatus.

Table maximo_eqstatus had 62995 row(s) loaded into it.

Database selected.


PDQ Priority set.


2 row(s) deleted.



Database closed.

Cannot open database 'sysmaster@mxprd01_tcp' - SQL error -908, ISAM error 22

End of LOADTABLES.SH
Wed Nov 17 03:41:38 EST 2004

Database selected.


1 row(s) retrieved.


Database closed.


Database selected.


1 row(s) retrieved.


Database closed.
 
Looks like network problems

$finderr 908

-908 Attempt to connect to database server (servername) failed.

The program or application is trying to access another database server
but has failed.

The desired database server is unavailable, or the network is down or
is congested. Ask your DBA and system administrator to verify that the
server and network are operational. If the network is congested, use
the environment variables INFORMIXCONTIME and INFORMIXCONRETRY to tune
connection timing. For information on setting these environment variable,
see the Informix Guide to SQL: Reference.

This message appears in Version 6.0 and later versions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top