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 > db2stop force hang

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-05-07, 03:18
zou_hope zou_hope is offline
Registered User
 
Join Date: Jul 2007
Posts: 6
db2stop force hang

When I ran 'db2stop force', it hang. I get the following messages in db2diag.log. Pls help me!
2007-07-02-12.22.42.666825+480 I32543726A297 LEVEL: Warning
PID : 524484 TID : 1 PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1780
MESSAGE : DB2 is waiting for log files to be archived.

2007-07-02-12.23.42.667245+480 I32544024A402 LEVEL: Warning
PID : 524484 TID : 1 PROC : db2loggr (ABSTEST) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpghck, probe:1800
DATA #1 : String, 131 bytes
DB2 was unable to confirm logs were archived.
Return code -2029059911, FirstArchNum 274, FirstArchNum2 4294967295, HeadExtentID 296

2007-07-02-12.28.44.681513+480 I32544427A383 LEVEL: Warning
PID : 921672 TID : 1 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000 DB : ABSTEST
APPHDL : 0-50 APPID: *LOCAL.db2inst1.070628165841
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:2330
MESSAGE : Some daemon is taking too long to shut down
Reply With Quote
  #2 (permalink)  
Old 07-05-07, 04:11
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
(same entry as in ittools)
are you using userexit or tsm or any other product to archive the log ?
do you have problems with regular archive of log ?
maybe the library manager (tsm) is busy or no tape drive is free
archive to tape or disk ?
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #3 (permalink)  
Old 07-05-07, 09:18
zou_hope zou_hope is offline
Registered User
 
Join Date: Jul 2007
Posts: 6
Quote:
Originally Posted by guyprzytula
(same entry as in ittools)
are you using userexit or tsm or any other product to archive the log ?
aix5L+db2+tsm+hacmp logretain=on


do you have problems with regular archive of log ?
no

maybe the library manager (tsm) is busy or no tape drive is free
there are two database in my instance
there is only one tape drive in my tap lib

archive to tape or disk ?
don't do it
Reply With Quote
  #4 (permalink)  
Old 07-05-07, 09:24
zou_hope zou_hope is offline
Registered User
 
Join Date: Jul 2007
Posts: 6
how can I confirm archive logs have being completed before I ran 'db2stop force'
Reply With Quote
  #5 (permalink)  
Old 07-05-07, 10:53
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
try the command
db2 archive log for db dbname
do you archive to tape/disk/tsm ?
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #6 (permalink)  
Old 07-05-07, 22:35
zou_hope zou_hope is offline
Registered User
 
Join Date: Jul 2007
Posts: 6
archive to TSM.

I don't use the following command before
db2 archive log for db dbname

I don't kown if this command is asynchronous, so it will return immediately. I can't comfiirm if log archive have been performed.

or this command is synchronous,it will not return before log archive operation have been performed completely.

Do anyone have the experience using this command? please help me

My machine is a product system, I can't test this command in it.
Reply With Quote
  #7 (permalink)  
Old 07-06-07, 09:48
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
if you use tsm there is a file ARCHIVE.LOG that will keep history about archived files with return code
there is also an entry in db2diag.log whenever a file is archived
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #8 (permalink)  
Old 07-09-07, 03:04
zou_hope zou_hope is offline
Registered User
 
Join Date: Jul 2007
Posts: 6
We assume that there are three active log files and two of them are full before I stop DB2.
I will stop all applications that connect to db2 before I ran "db2stop force".
In that time, two full log will be closed and beginning to archive.
I can confirm the two log archive have been performed through looking at db2diag.log or ARCHIVE.LOG. I can ran " db2stop force"

BUT how can I confirm how many active full logs are there before I stop db2

I can kown the first active log file through looking at "db cfg"
Reply With Quote
  #9 (permalink)  
Old 07-09-07, 09:45
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
whenever an active log file is full, it will be archived immediatly and another log file will be requested
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #10 (permalink)  
Old 07-12-07, 06:26
zou_hope zou_hope is offline
Registered User
 
Join Date: Jul 2007
Posts: 6
Dear guyprzytula !

One active log file witch is full will be archived until all tranctions in it are commited or rollbacked
Reply With Quote
  #11 (permalink)  
Old 07-12-07, 06:54
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
according the doc
When archiving, a log file is passed to the user exit when it is full, even if the log file is still active and is needed for normal processing. This allows copies of the data to be moved away from volatile media as quickly as possible. The log file passed to the user exit is retained in the log path directory until it is no longer needed for normal processing. At this point, the disk space is reused.
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
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