Hi ,
Wat about kill command
we should first do
db2 "force applications all"
then, wait for some time; if this hangs, in another window, execute
db2stop force
Now, if the db2stop does not work or hangs, then issue a db2_kill.
We had this situation with DB2 8.1 FP-3. When we were issuing db2_kill
the engine was crashing and after doing a 'ipclean', it was fine.
When you start the engine again, it goes to crash recovery and after that,
everything was normal.
Hope this helps.
Just my input need more comments on it
Thanks,
Nadeem Khan
-----Original Message-----
From: Jagdish Singh Rawat NCS [mailto:db2udbdba-ezmlmshield-x53771614.[Email address protected]
Sent: Wednesday, March 12, 2008 7:27 AM
To: LazyDBA Discussion
Subject: RE: ERROR db2 force application all
First check is db2 operational.
If yes then definitely "db2 force application/applications all" with work
If not then first start db2 engine.. "db2start"
Then try the force command.
Hope this help.
Regards,
Jagdish S. Rawat
IBM Certified Advance DB2DBA
NCS Pte. Ltd.
5 Ang Mo Kio St 62, NCS Hub
Singapore - 569141
Ph.# +65-65565870(Direct) +65-65568000 Ext. # 5870
HP.# +65-96425135
Fax# +65-64830495
-----Original Message-----
From: lei [mailto:db2udbdba-ezmlmshield-x87161082.[Email address protected]
Sent: Tuesday, March 11, 2008 6:06 PM
To: LazyDBA Discussion
Subject: Re: ERROR db2 force application all
Thanks Ed
Thanks for your help. I successfully executed the "db2admin start"
STATEMENT.
When i do "db2 force application all", the error again...
Regards
lei
--------------------------------------------------
From: "Edwards Ed "
<db2udbdba-ezmlmshield-x61782991.[Email address protected]
Sent: Monday, March 10, 2008 5:47 PM
To: "LazyDBA Discussion" <[Email address protected]
Subject: RE: ERROR db2 force application all
> Well, well, well!
> It's zzhleixx! Hehe. How have you been? First, try the following
> command.
>
> db2admin start
>
> Then try your command again! Hehe.
>
> Have a great Day!
>
>
>
>
>
>
> Please take a few minutes to provide feedback on the quality of service
> you received from our staff. The Department of Education values your
> feedback as a customer. Commissioner of Education Dr. Eric J. Smith is
> committed to continuously assessing and improving the level and quality of
> services provided to you.Simply use the link below. Thank you in advance
> for completing the survey.
>
>
> http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>
>
>
>
> -----Original Message-----
> From: zzhleixx [mailto:db2udbdba-ezmlmshield-x79218913.[Email address
> protected]
> Sent: Monday, March 10, 2008 2:37 AM
> To: LazyDBA Discussion
> Subject: ERROR db2 force application all
>
> hi,
> i am trying to execute db2 force application allbut.....SQL1032N No start
> database manager command was issued. SQLSTATE=57019
>
> db2diag.log
>
> 2008-03-10-08.47.54.964533+480 I1G1393 LEVEL: EventPID : 12476 TID :
> 3085883072 PROC : db2agent (HNSALE) 0INSTANCE: db2inst1 NODE : 000 DB :
> HNSALEAPPHDL : 0-961 APPID: 10.65.128.44.54934.080322151715AUTHID :
> NBADVFUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120START :
> New Diagnostic Log fileDATA #1 : Build Level, 128 bytesInstance "db2inst1"
> uses "32" bits and DB2 code release "SQL09010"with level identifier
> "02010107".Informational tokens are "DB2 v9.1.0.0", "s060629",
> "LINUXIA32", Fix Pack "0".DATA #2 : System Info, 436 bytesSystem: Linux
> 10.65.128.44 6 2 i686CPU: total:8 online:8 Cores per socket:2 Threading
> degree per core:2Physical Memory(MB): total:8115 free:1408Virtual
> Memory(MB): total:16117 free:9409Swap Memory(MB): total:8002
> free:8001Kernel Params: msgMaxMessageSize:8192 msgMsgMap:16384
> msgMaxQueueIDs:1024msgNumberOfHeaders:16384
> msgMaxQueueSize:16384msgMaxSegmentSize:16 shmMax:268435456 shmMin:1
> shmIDs:4096shmSegments:4096 semMap:32000 semIDs:1024
> semNum:32000semUndo:32000 semNumPerID:250 semOps:32
> semUndoSize:20semMaxVal:32767 semAdjustOnExit:32767Information in this
> record is only valid at the time when this file wascreated (see this
> record's time stamp)
> _________________________________________________________________
> 手机也能上 MSN 聊天了，快来试试吧！
> http://mobile.msn.com.cn/
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
DB2 & UDB email list listserv db2-l LazyDBA home page