473,320 Members | 2,109 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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
0 2540

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: bmiras | last post by:
I've got a problem using urllib2 to get a web page. I'm going through a proxy using user/password authentification and i'm trying to get a page asking for a HTTP authentification. And I'm using...
0
by: Anil Garg | last post by:
Hi, I am trying to install myql on redhat. mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz While following the instructions in install document..when i run the follwing...
8
by: Jeff B | last post by:
Hello, Im learning PHP along with MySql. I installed MySql with no problem and have completed several tutorials to learn it. Now when trying to use PHP code within an html page it dosn't...
0
by: Hari Sekhon | last post by:
I've written an xml parser using xml.sax which works most of the time but often traces back when trying to read a file. The output of the traceback is below: Traceback (most recent call last):...
0
by: youth | last post by:
I am trying to bind the DB2 utlities to a new database that was created by our DBAs. Each time I try I get the following: db2ajgrt.bnd - No errors db2clish.bnd - 13 errors all for missing...
3
by: Hospital S.Sebastiao | last post by:
Hi, i'm in desperate need of help to fix a problem that i have, the problem is the following: I have an ASP.NET aplication that to open an word template document, this aplication is in C#(using...
5
Atli
by: Atli | last post by:
Hi guys. So, I got it into my head this morning that I needed a Linux HTTP server. Naturally that means installing Apache with PHP and last but not least, MySQL. I decided to use Fedora Code...
6
by: Wiseman | last post by:
Hi, The line: import enchant works perfectly OK when I call a Python progrma (sp.py) from IDLE (WInXP). When I try to run it ftom the command line (python sp.py) the response is:
1
by: eblackmo | last post by:
I have a test network consisting of four servers running windows 2003 server R2 SP2. I have set up a domain which functioned correctly for about a day and a half until the other servers decided they...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.