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
Limit on DB2 Stage Input Link
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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