If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 DPF on AIX - SQL1025N error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-13-10, 12:38
stj20 stj20 is offline
Registered User
 
Join Date: Jun 2010
Posts: 34
DB2 DPF on AIX - SQL1025N error

Hi , When I tried to stop db2 instance , I had the error 'database is in use'. Then I listed the application and couldn't see any. Then I displayed the IPCS and cleaned them. Then I tried to stop the db2 instance again. I am getting the following errors :
a)SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing ( For all partitions)

b) SQL1025N The database manager was not stopped because databases are still active

When I display the IPCS again then I can see many Message ids(m) and Queues(q) for the instance. Should I need to cancell this individually or is there better way forward to resolve this issue ?
Thanks.
Reply With Quote
  #2 (permalink)  
Old 09-13-10, 13:47
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Applications may be connected to other partitions, may they not?
Reply With Quote
  #3 (permalink)  
Old 09-13-10, 19:24
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by stj20 View Post
When I tried to stop db2 instance , I had the error 'database is in use'. Then I listed the application and couldn't see any. Then I displayed the IPCS and cleaned them.
You should also check that the the db has not been activated using the activate db command. You can issue "list active databases" to check. If a db is listed with zero applications currently connected, then use the deactivate db command to deactivate it. The only time you might need to remove IPC resources is when an application(s) won't go away with the force application / db2stop force command. In this case, issue db2_kill followed by ipclean and then check for / remove all remaining processes / IPC resources associated with this instance (on all physical nodes)
Reply With Quote
  #4 (permalink)  
Old 09-14-10, 00:07
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
If you have more than one physical server (in a multi-partitioned database) you need to run IPCS on each server.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old 09-14-10, 11:55
stj20 stj20 is offline
Registered User
 
Join Date: Jun 2010
Posts: 34
Thanks everyone. Finally it stopped. I managed to start without any issue. But I can see some warning messages. Just for curiosity what are these refring to ?

2010-09-11-16.35.44.757931+060 E88189A387 LEVEL: Warning (OS)
PID : 3350664 TID : 1 PROC : db2sysc 4
INSTANCE: db2test1 NODE : 004
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
CALLED : OS, -, unspecified_system_function
OSERR : ENOENT (2) "No such file or directory"
DATA #1 : File name, 0 bytes
Reply With Quote
  #6 (permalink)  
Old 09-14-10, 22:51
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
It should also print the file name. You can ignore this message if there are no errors logged at around the same time.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On