DSXchange

Hi,
One of our jobs has 10 input links to a DB2 Stage.
Everytime we tried to run the Job, it failed, with a message:

"CIF40TSDSIFM01..Write_STGDB: [IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032
Unable to connect to DB2 server 'STGDB'."

Have any of you found the same problem before?
I tried to reduce the number of input links down until 7, then the Job works.

Kindly advise...


Regards

ND

Sounds to me like a configuration issue in DB2; the number of agent processes that can be started by a single requestor.
Try running the ten links into, say, two separate stages, so that each is only handling five input links. Or, at the extreme, use ten different DB2 stages (though this may have licensing implications!)

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518