Topic
1 reply Latest Post - ‏2013-02-05T06:41:49Z by mwandishi
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic Database Directory: Delete Indirect entry type

‏2013-02-05T06:36:22Z |
Dears,

For some reason, I wanted to use remote entry type(TCP/IP protocol) instead of Indirect(why called 'Indirect', it is the same as IPC standing for interprocess communication?) when the DB2 client and server reside in the same machine.

see: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.pd.doc/pd/t0020792.htm

What I did is I deleted the directory with Indirect type and recreate a remote directory with the same db name. But I got the follow error when I try to connect to the database.(It is ok if i use a different name to create the remote directory)
SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request
because of an error or a forced interrupt. SQLSTATE=55032

Does any one encounter this problem before? Is there any official documentation specify why this is happened?
Thanks,
Ricky Ru
Updated on 2013-02-05T06:41:49Z at 2013-02-05T06:41:49Z by mwandishi
  • mwandishi
    mwandishi
    47 Posts
    ACCEPTED ANSWER

    Re: Database Directory: Delete Indirect entry type

    ‏2013-02-05T06:41:49Z  in response to SystemAdmin
    Hi Ricky,

    The first thing to try is a refresh of the catalog cache: db2 terminate,
    You often get the -1224 if a preexisting db2bp session is accessing the cached data.

    If this doesn't work then we'll need to look a little deeper.

    Best regards,Stephen Levett