DB2 View Data error SQL1224N The database manager is not ab

[fede120]

Hello there;

I'm running IIS v8.0.1 FP1a on AIX 5.3.0.0. I have a simple Parallel job that reads data from a DB2 9.1 (local on AIX) using DB2 API stage, and a Peek stage. The job runs Ok, and if I go to Director I see the data. But if I try to do a "View Data" on the DB2 API stage I get this:

DSBrowser..DB2_UDB_API_0: [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated your particular request due to a problem with your request. SQLSTATE=55032

DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 'EMPLOY'.
DSBrowser..DB2_UDB_API_0.DSLink1: DSP.Open GCI $DSP.Open error -100.

I tried with a Server job (using a Seq stage instead a Peek stage): it runs Ok, the file and data are there, but If I do a View Data on the DB2 API stage I got the same error.

Any ideas?

[ray.wurlod]

How busy is the database server, or is it in the process of being shut down or quiesced when these messages appear?

[fede120]

This is a Test environment, and I'm the only one working with the database server (and DS). I don't think this could be a database server issue, since the job runs Ok. It's just the "view data" button problem.

This is how looks db2 entry in dsenv file:

##################################
# DB2 Version 9 - Agregadas por Fede 26.06.08

DB2DIR=/opt/IBM/db2/V9.1; export DB2DIR
DB2INSTANCE=db2inst1; export DB2INSTANCE
INSTHOME=/home/db2inst1; export INSTHOME
PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc:$DB2DIR/bin; export PATH
LIBPATH=$INSTHOME/sqllib/lib32; export LIBPATH
THREADS_FLAG=native; export THREADS_FLAG

DB2PATH=$INSTHOME/sqllib/bin; export DB2PATH
##############################

and this is db2 list applications ouput

$ db2 list applications

Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2taskd 1388 *LOCAL.DB2.080701191025 EMPLOY 1
DB2INST1 db2stmm 1389 *LOCAL.DB2.080701191024 EMPLOY 1
XMETA db2jcc_applica 1360 127.0.0.1.58602.080701185740 XMETA 1
XMETA db2jcc_applica 1246 127.0.0.1.58262.080701172500 XMETA 1
XMETA db2jcc_applica 313 127.0.0.1.37819.080627210221 XMETA 1
XMETA db2taskd 294 *LOCAL.DB2.080627205636 XMETA 1
XMETA db2stmm 292 *LOCAL.DB2.080627205635 XMETA 1

[John Smith]

Are you using Job Parameters? When you run the job do you change any of the job parameters? Perhaps when you do a view data you are just using Default values as specified in the Job parameters?

[fede120]

I'm not using Job Parameters. It's a very simple job:

DB2 API -> Peek

that's all.