Simon; When you say that the db2stop stalls, do you mean that you get a message that the database is in use? I have seen situations where I do a FORCE APPLICATIONS ALL and try to take a backup and get the message that the database is in use. These appear to be caused by run away backend processes. Like you, I used IPCRM to remove the offending processes.
This happens less frequently in later releases of DB2. Regards, Scott Saunders Siebel Systems, Inc. Opinions expressed are my own and not those of my employer. -----Original Message----- From: Dimoline, Simon [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 6:57 AM To: [EMAIL PROTECTED] Subject: DB2EUG: db2 stalls on db2stop command Dear All, Can anyone help on this. We are running scripts to update one instance of a database (d2), once updated it is then backed up and the backup used to refresh the live instance of the database(d1). (AIX and db2 version 5.2) Occassionally, and this is only on the d2, during the final terminate, stop and start commands the instance stalls on the db2stop command. The db2 processes running at that time are: db2gds db2tcpim db2sysc db2tcpcm db2ipccm /db2/d2/sqllib/bin/db2bp 38120 5 /db2/d2/sqllib/adm/db2stop2 We have to kill the first five processes and run a process to clean up the db resources using ipcs then ipcrm. The database is then manually stopped and started. Can anyone suggest why it stalls and how to rectify this. We suspect it is to do with buffer space or memory but we're not sure. One thing we have noticed is that there is a resource that ipcrn won't delete, it just says resource not found. There are also 2 messages produced in the script reports. The first, SQL1042C probably related to the db2stop and SQL1072C probably related to the next command, db2start. However, these are produced after the initial 5 db2 processes are killed so may be a red herring. Simon. "This communication is intended solely for the addressee and is confidential and not for third party unauthorised distribution." ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
