Topic
1 reply Latest Post - ‏2012-12-14T13:37:17Z by SystemAdmin
Leo_52
Leo_52
69 Posts
ACCEPTED ANSWER

Pinned topic SQL22212 Error

‏2012-12-03T17:13:47Z |
To whom this may concern

When issuing the runstats command the other day, DB2 Express-C returned the ubiquitous SQL22212 error message. Online help wasn't useful at all! Since the last successful runstats was issued on the 16th of November 2012, I decided to play back a system image, created on the 14th of November 2012, and try again. Surprise, surprise: SQL22212 came up again!

'If DB2 fails, then SQL Server may fail too' (IBM DB2 error info refers to TCP/IP addresses) I thought and checked SQL Server – absolutely no problems there, so TCP/IP can't be the culprit!

Looking further into DB2 Express-C behavior I found out that DB2 became more or less defunct - commands being rejected.

I have uninstalled DB2 Express-C until a viable solution is available and use Microsoft SQL Server instead. It came in very handy that I duplicated all DB2 databases on Microsoft SQL Server!

DB2 Express-C 9.n was installed on Windows 7 Ultimate 64 Bit SP1.

Has anybody come across this strange SQL22212 behavior and is there a solution one could share?

Any answer would be appreciated.
Leo
Updated on 2012-12-14T13:37:17Z at 2012-12-14T13:37:17Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: SQL22212 Error

    ‏2012-12-14T13:37:17Z  in response to Leo_52
    Hello,

    Can you be more specific about what you attempt when SQL22212N is returned ??
    - which client application are you using ?
    - which action do you perform within this application ?

    Also check that the administration server service is started.

    Regards

    Yves-Antoine Emmanuelli