Hi newsgroup,
I try to connect to a host db2 (DB2 OS/390 7.1.2) from my db2 client on
windows (DB2/NT 8.2.3).
Using interactive mode everything works fine (db2, connect to abc user x
using y, select z from schema.tablename).
But for automation I would like to put my query in an SQL file and run
it using db2sql92.exe
db2sql92.exe -d abc -f "C:\test.sql" -a user/pass -r c:\query.out
This command results in the following error message:
"
SQL30104N Fehler in BIND- oder PRECOMPILE-Option "LANGLEVEL" mit dem
Wert "MIA ". SQLSTATE=56095
---------------------------------------------
Statement # 1 :
SELECT z from schema.tablename
SQL0805N Paket "EUCADB2B.NULLID.TOOL3E00.4141414141614853" nicht
gefunden. SQLSTATE=51002
"
(Translation: Package ... was not found)
If I issue the above mentioned command outside the SQLLIB/bnd directory
I get:
"
SQL0031C Die Datei "C:\Program Files\IBM\SQLLIB\BIN\DB2SQL92.BND"
konnte nicht geöffnet werden.
"
instead of the SQL30104N line above plus the rest of the above message.
The db2diag.log on the client is attached below ([2])
What is different db2-intern if db2sql92 is used?
I would like to understand whats wrong there and if some packages on the
host must be bind or some/what privileges are missing.
Any hint is welcome. I already took a look at db2 infocenter [1] but my
knowledge seems insufficient to formulate an answer out of this information.
With kind regards,
Michael Rudolph
PS: Sorry for german output. Little question beside the topic: How do i
change the language of my db2 client to english? Is it possible after
installation?
[1]
http://publib.boulder.ibm.com/infoce...t/rlsdb208.htm
[2]
"
2006-02-27-17.18.03.817000+060 I18200194H399 LEVEL: Warning
PID : 13972 TID : 13712 PROC : db2sql92.exe
INSTANCE: DB2CTLSV NODE : 000
APPID : G99C5022.DE0B.06C247161803
FUNCTION: DB2 UDB, aps binder service, sqlajbnd_process, probe:2817
MESSAGE : Error code
DATA #1 : Hexdump, 4 bytes
0x0011CB28 : 688A FFFF h...
2006-02-27-17.18.03.817000+060 I18200595H713 LEVEL: Warning
PID : 13972 TID : 13712 PROC : db2sql92.exe
INSTANCE: DB2CTLSV NODE : 000
APPID : G99C5022.DE0B.06C247161803
MESSAGE : sqlaj_error_struct
DATA #1 : Hexdump, 88 bytes
0x0011CAA0 : 4150 534A 010B 0000 3238 3137 0000 0000 APSJ....2817....
0x0011CAB0 : 0000 0000 688A FFFF 7371 6C61 6A50 7265 ....h...sqlajPre
0x0011CAC0 : 7069 6E69 7400 0000 0000 0000 0000 0000 pinit...........
0x0011CAD0 : 0000 0000 0000 010B 4261 6420 7371 6C61 ........Bad sqla
0x0011CAE0 : 6A50 7265 7069 6E69 7400 0000 0000 0000 jPrepinit.......
0x0011CAF0 : 0000 0000 0000 0000 ........
2006-02-27-17.18.03.837000+060 I18201310H399 LEVEL: Warning
PID : 13972 TID : 13712 PROC : db2sql92.exe
INSTANCE: DB2CTLSV NODE : 000
APPID : G99C5022.DE0B.06C247161803
FUNCTION: DB2 UDB, aps binder service, sqlajbnd_process, probe:2817
MESSAGE : Error code
DATA #1 : Hexdump, 4 bytes
0x0011CB28 : 688A FFFF h...
2006-02-27-17.18.03.837000+060 I18201711H713 LEVEL: Warning
PID : 13972 TID : 13712 PROC : db2sql92.exe
INSTANCE: DB2CTLSV NODE : 000
APPID : G99C5022.DE0B.06C247161803
MESSAGE : sqlaj_error_struct
DATA #1 : Hexdump, 88 bytes
0x0011CAA0 : 4150 534A 010B 0000 3238 3137 0000 0000 APSJ....2817....
0x0011CAB0 : 0000 0000 688A FFFF 7371 6C61 6A50 7265 ....h...sqlajPre
0x0011CAC0 : 7069 6E69 7400 0000 0000 0000 0000 0000 pinit...........
0x0011CAD0 : 0000 0000 0000 010B 4261 6420 7371 6C61 ........Bad sqla
0x0011CAE0 : 6A50 7265 7069 6E69 7400 0000 0000 0000 jPrepinit.......
0x0011CAF0 : 0000 0000 0000 0000 ........
"