Error while connecting to DB2 Z/OS from DataStage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shsandeep - 03 Jul 2006 06:53 GMT

We are trying to connect from DataStage to a DB2 database on Z/OS. It
connects fine from the DataStage server, but when connecting from
DataStage client it gives the following error:

DSR.MetaGeta(GET.TABLES)(SQLConnect('USABCCP1','uspsxs')): BCI Error:
SQLSTATE=08S01,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2
Wire Protocol driver]Permanent Agent Error.

Has anybody encountered this before? Any ideas will be very helpful.

Cheers,
San.

Reply to this Message

Jeroen van den Broek - 03 Jul 2006 22:58 GMT

> We are trying to connect from DataStage to a DB2 database on Z/OS. It
> connects fine from the DataStage server, but when connecting from
[quoted text clipped - 8 lines]
> Cheers,
> San.

This isn't as much a DB2 for z/OS problem, as well as a problem with the
DataDirect ODBC driver (in this case the DB2 Wire Protocol driver).
You'll find some related info (for Oracle) here:
http://knowledgebase.datadirect.com/kbase.nsf/SupportLink+Online/2549933EC?OpenD
ocument

Probably you will be better off describing your problem on the DataDirect
Support forum:
http://forums.datadirect.com/ddforums/index.jspa

HTH.

Signature

Jeroen

Reply to this Message

Pierre Saint-Jacques - 04 Jul 2006 20:32 GMT

Question #1
The event monitor data is written to two buffers which you can size in the
event definition at create time.
The data is flushed to file or table when the buffer is full or when the
FLUSH command is issued.
It is possible, because of low activity that an event monitor for connection
or table activity does not see ebough activity on the object for the buffer
to fill and flush.
This may be why you only see activity after the flush even though there are
active connection(s) on the db.

HTH, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>
>> We are trying to connect from DataStage to a DB2 database on Z/OS. It
[quoted text clipped - 20 lines]
>
> HTH.

Reply to this Message

Jeroen van den Broek - 05 Jul 2006 18:22 GMT

> Question #1
> The event monitor data is written to two buffers which you can size in the
[quoted text clipped - 12 lines]
> SES Consultants Inc.
> 514-737-4515

I guess this was meant for another thread in this ng, 'event
monitoring' ?!

Signature

Jeroen

Reply to this Message

shsandeep - 05 Jul 2006 04:56 GMT

Thank you to all who replied.
I managed to sort out the issue. DataStage was using DataDirect drivers
for connectivity. We tried using the native DB2 driver and it worked.
Sometimes the DataDirect driver and DB2 version have some incompatibilty,
etc.
Anyways, now its solved... thanks once again.

Cheers,
San.

Reply to this Message