SQL0902C on db2 connect
in [DB2]
|
From: Christian Welzel on 29 Nov 2009 11:55 Hi there, I have a problem with the connect to db2... Whenever i call "db2 connect to DB" on the system where the db2 runs, i get the following error: SQL0902C A system error (reason code = "") occurred. Subsequent SQL statements cannot be processed. Connects from other machines, where the db is registered as remote system work fine. (DB2 9.7 Express-C on Linux/Amd64) Where can i find informations, what the cause of this issue can be? -- MfG, Christian Welzel aka Gawain(a)Regenbogen GPG-Key: http://www.camlann.de/key.asc Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
From: Sawan on 29 Nov 2009 18:55 On Nov 29, 9:55 pm, Christian Welzel <gaw...(a)camlann.de> wrote: > Hi there, > > I have a problem with the connect to db2... > Whenever i call "db2 connect to DB" on the system where the db2 runs, > i get the following error: > > SQL0902C A system error (reason code = "") occurred. Subsequent SQL > statements cannot be processed. > > Connects from other machines, where the db is registered as remote system > work fine. (DB2 9.7 Express-C on Linux/Amd64) > > Where can i find informations, what the cause of this issue can be? > > -- > MfG, Christian Welzel aka Gawain(a)Regenbogen > > GPG-Key: http://www.camlann.de/key.asc > Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15 Hi Christian Have you checked db2diag.log ? Regards, Sawan Gupta
From: Christian Welzel on 1 Dec 2009 12:39 Sawan wrote: > Have you checked db2diag.log ? Thanks for that hint! Now i know this: DIA8336C Requested too many semaphores. From looking into the google it seems this should cause the seen behaviour... know i only need to fix the vserver. Thanks! -- MfG, Christian Welzel aka Gawain(a)Regenbogen GPG-Key: http://www.camlann.de/key.asc Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
|
Pages: 1 Prev: Need OLAP-type Ordering Next: recursively get previous row using OLAP functions |