DSXchange

Hi,
I am facing an issue with using parallel odbc connections to a DB2 database( my source) on an OS/390.
I have DS EE 7.5.1 on an AIX 5.3 box.
Source DB2 is on an OS390/ZOS.
When I use an odbc connection to the source,the dba's are complainig the security logs get filled up ( more specifically the password has expired and hence the security logs on the source DB2 getting filled Up).
here is my .odbc.ini entry for
------------------------------------
[csd]
QEWSD=38864
Driver=/dstage/Ascential/DataStage/branded_odbc/lib/VMdb220.so
Description=DataDirect 5.00 DB2 Wire Protocol Driver
AddStringToCreateTable=
#SecurityMechanism=2
AlternateID=
Collection=nullid
Database=CDNXDB1Q
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=10.1.1.5
IsolationLevel=CURSOR_STABILITY
#Location=OS/390 and AS/400 (Remove for DB2 UDB)
LogonID=*****
Password=******
Package=CSDDV
PackageOwner=******
TcpPort=347
WithHold=1

------------------------------------


We haven't changed any password for the userdid that I am using.
Couple of times the job runs successfully.
Has anyone experienced this issue .

Any help is greatly appreciated.

Thanks,
MB

The DBA might have changed the password, or it may have expired due to too many failed login attempts. It's not something you can correct from DataStage except by getting the user/password combination right.

Thanks for the quick repsonse Ray.....

This has occured multiple times......We made sure we have the correct userId/password. The first time around when we got this error the password was set and we re-ran our jobs . The same error was reported by the DBA's.

A side question since my source is DB2 database, will I be able to use a DB2 API stage. 'Cause the DB2 API stage is for a DB2 UDB database in DS. Can't get a firm answer from the DBA if this is indeed a UDB database for a good ole DB2.

Any thoughts..

The DB2 Enterprise stage should be your preferred stage type.

However, if you need to access DB2 tables via DB2 Connect, for example because they're on a mainframe or AS/400 system, then you need to use the DB2/UDB API stage.

Thanks Ray will try it out and let y'alll know