Troubleshooting

Problem
DB2 returns SQL1044N when I try to start DB2 Error snippet: db2start SQL1044N “Processing was cancelled due to an interrupt.” Explanation The user may have pressed the interrupt key sequence. Processing is stopped. Federated system users: this situation can also be detected by the data source.http://www.cndba.cn/hbhe0316/article/108534

Symptom
When executing db2start command

Cause
Make sure that there are no IPCS resources.

1. Check if there are existing IPCS resources running in the background

   ipcs | grep -i db2
   

2. If there are IPC resources, then kill any ipcs by running ipcrm (outlined in the resolution below)

Environment
AIX, Linux

Diagnosing The Problem
To determine if IPCS resources is running, enter the following in command-linehttp://www.cndba.cn/hbhe0316/article/108534http://www.cndba.cn/hbhe0316/article/108534http://www.cndba.cn/hbhe0316/article/108534http://www.cndba.cn/hbhe0316/article/108534

ipcs | grep -i db2

Resolving The Problem
To fix the problem, kill any IPCS resources by running the following command:

ipcrm <ipcs prcesses>

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2