CDC Guide for Linux, UNIX, and Windows

10.4.0 HotFix 1
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Workaround for SQL1224 Error on AIX

On AIX systems only, you might receive the following PowerExchange message for a Db2 SQL1224 error when you connect locally to a Db2 database that has multiple other local connections:

PWX-20604 State=08001, Code=-1224, Msg=[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.

To circumvent this problem, implement a loopback TCP/IP connection for the local Db2 database. The database can then function as a remote client that uses TCP/IP instead of interprocess communications (IPC) over shared memory.

To implement a loopback connection without changing the database alias that users enter for database connection, issue the following Db2 commands:

db2 catalog tcpip node node_name1 remote server_name1 server port_number1 
db2 uncatalog database database_name1
db2 catalog database database_name1 at node node_name1
db2 catalog database database_name1 as database_alias1
db2 catalog database database_alias1 as database_name1 at node node_name1