By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,729 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Problem using db2sql92 on host db2 (Langlevel or missing package)

P: n/a
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 ........
"
Feb 27 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.