MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

question about offload log of DB2,transaction abnomal

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
issac1029
Intermediate


Joined: 10 Dec 2005
Posts: 159
Topics: 75
PostPosted: Wed Jul 05, 2006 4:15 am    Post subject: question about offload log of DB2,transaction abnomal Reply with quote
Quote:
Display Filter View Print Options Help
-------------------------------------------------------------------------------
SDSF OUTPUT DISPLAY DB1TMSTR STC03307 DSID 2 LINE 1,030,750 COLS 01- 80
COMMAND INPUT ===> SCROLL ===> CSR
704 CATLG=YES
13.23.35 STC03307 DSNJ003I -DB1T DSNJOFF3 FULL ARCHIVE LOG VOLUME 708
708 DSNAME=DSNDBTG.DB1T.ARCLG2.D06186.T1322119.A0017568,
708 STARTRBA=046E3CB04000, ENDRBA=046E5C543FFF, STARTLRSN=BF0DE2
708 ENDLRSN=BF0DF190289A, UNIT=SYSDA, COPY2VOL=STB097, VOLSPAN=0
708 CATLG=YES
13.23.35 STC03307 DSNJ139I -DB1T LOG OFFLOAD TASK ENDED
13.26.16 STC03307 DSN3201I -DB1T ABNORMAL EOT IN PROGRESS FOR 386
386 USER=RABNG CONNECTION-ID=TSO CORRELATION-ID=RABNG JOBNAME=RA
386 ASID=01E0 TCB=00A96748
13.34.20 STC03307 DSN3201I -DB1T ABNORMAL EOT IN PROGRESS FOR 919
919 USER=RAZSA CONNECTION-ID=BATCH CORRELATION-ID=RAZSA84D
919 JOBNAME=RAZSA84D ASID=034E TCB=00AE29C0
13.38.10 STC03307 DSN3201I -DB1T ABNORMAL EOT IN PROGRESS FOR 135
135 USER=RAZSA CONNECTION-ID=BATCH CORRELATION-ID=RAZSA84D
135 JOBNAME=RAZSA84D ASID=04B0 TCB=00AE29C0
13.45.08 STC03307 DSN3201I -DB1T ABNORMAL EOT IN PROGRESS FOR 665
665 USER=RANUR CONNECTION-ID=TSO CORRELATION-ID=RANUR JOBNAME=RA
665 ASID=0196 TCB=00AE97C0
13.45.10 STC03307 DSN3201I -DB1T ABNORMAL EOT IN PROGRESS FOR 678


When I do transaction it return -911
Quote:
Display Filter View Print Options Help
-------------------------------------------------------------------------------
SDSF OUTPUT DISPLAY DB1TMSTR STC03307 DSID 2 LINE CHARS 'LOG' FOUND
COMMAND INPUT ===> SCROLL ===> CSR
14.51.19 STC03307 DSNJ002I -DB1T FULL ACTIVE LOG DATA SET 400
400 DSNAME=DSNDBTG.DB1T.LOGCOPY1.DS05, STARTRBA=046E5C544000,
400 ENDRBA=046E7BF83FFF
14.51.19 STC03307 DSNJ001I -DB1T DSNJW307 CURRENT COPY 1 ACTIVE LOG 401
401 DATA SET IS DSNAME=DSNDBTG.DB1T.LOGCOPY1.DS06,
401 STARTRBA=046E7BF84000,ENDRBA=046E9B9C3FFF
14.51.19 STC03307 DSNJ002I -DB1T FULL ACTIVE LOG DATA SET 402
402 DSNAME=DSNDBTG.DB1T.LOGCOPY2.DS05, STARTRBA=046E5C544000,
402 ENDRBA=046E7BF83FFF
14.51.19 STC03307 DSNJ001I -DB1T DSNJW307 CURRENT COPY 2 ACTIVE LOG 403
403 DATA SET IS DSNAME=DSNDBTG.DB1T.LOGCOPY2.DS06,
403 STARTRBA=046E7BF84000,ENDRBA=046E9B9C3FFF
14.51.19 STC03307 MSGACC0055 DD=SYS03997 DSN=DSNDBTG.DB1T.ARCLG1.D06186.T14511
14.51.19 STC03307 SGC0410 FOR ALLOCATE DSNDBTG.DB1T.ARCLG1.D06186.T1451194.B00
14.51.19 STC03307 SGC0414 *** WARNING *** 'DB2S1 RND' (PERM) IS AT 90% OF BUDG
14.51.19 STC03307 MSGACC0055 DD=SYS03998 DSN=DSNDBTG.DB1T.ARCLG1.D06186.T14511
14.51.20 STC03307 SGC0410 FOR ALLOCATE DSNDBTG.DB1T.ARCLG1.D06186.T1451194.A00
14.51.20 STC03307 SGC0414 *** WARNING *** 'DB2S1 RND' (PERM) IS AT 91% OF BUDG
14.51.20 STC03307 MSGACC0055 DD=SYS03999 DSN=DSNDBTG.DB1T.ARCLG2.D06186.T14511
14.51.20 STC03307 SGC0410 FOR ALLOCATE DSNDBTG.DB1T.ARCLG2.D06186.T1451194.B00


So I think -911 is because dba is doing archive log offload and make new
log file?Right?
Does the unload hold my tablespace?How to know which volum foe archive log use is locking my tablespace?Or before all volumn offlod
ended,any call to DB2 would unsuccessful.Am I right about that?

Quote:
SQL ERROR IN PROGRAM GRBOM100 AT 3950

***** SQLCA DETAILS *****
SQLCODE : -911 ( SQLSTATE : 40001 )
ERRMC : 00C9008E 00000304 OZRBD061.TSRBT183.X'000003' '.X'02'
SQLERRP : DSNXRRC
SQLERRD3 : 13172878 ; SQLERRD4 : 1108613524 ; SQLERRD5 : -1010298877
***** END OF SQLCA DETAILS *****
Back to top
View user's profile Send private message Send e-mail MSN Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12385
Topics: 75
Location: San Jose
PostPosted: Wed Jul 05, 2006 7:26 am    Post subject: Reply with quote
issac1029,

You got a dead lock on trying to get a lock request on Table space RID (resource type 00000304) named OZRBD061.TSRBT183.X'000003' '.X'02'

Here is an explanation of the error code 00C9008E

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/4.8.18?SHELF=&DT=20010718150520&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
videlord
Beginner


Joined: 09 Dec 2004
Posts: 147
Topics: 19
PostPosted: Thu Jul 06, 2006 12:39 pm    Post subject: Reply with quote
It's time out, not dead lock.

The row you are checking is locked by other transaction/user, and it didn't release the lock until time-out
Back to top
View user's profile Send private message
issac1029
Intermediate


Joined: 10 Dec 2005
Posts: 159
Topics: 75
PostPosted: Fri Jul 07, 2006 4:55 am    Post subject: Reply with quote
If a program is runing with out sql commit,the previous update on table would lock those data?That means if I update the table and lock page A,then before I commit
you can not update this page?How about just to select?
Back to top
View user's profile Send private message Send e-mail MSN Messenger
videlord
Beginner


Joined: 09 Dec 2004
Posts: 147
Topics: 19
PostPosted: Fri Jul 07, 2006 2:55 pm    Post subject: Reply with quote
yes, update is X-lock, it block other access untill it released.
select is S-lock, still a lock there, but usually it can be concurrent accessed by others (share lock)
you can read some books about DB2 lock.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group