Author |
Message |
Topic: RECOVER PENDING and REBUILD PENDING |
Arun
Replies: 1
Views: 3834
|
Forum: Database Posted: Fri Jun 27, 2003 4:44 pm Subject: RECOVER PENDING and REBUILD PENDING |
Hi,
I rebuilt index on one of my DB2 table with the following command
REBUILD INDEX(XBCW.I123011C)
Job ran with a Return code 8 and with the following message
INDEX XBCW.I123011C IS IN REC ... |
Topic: Is this the way this SQL is required? |
Arun
Replies: 3
Views: 2346
|
Forum: Database Posted: Thu May 29, 2003 3:46 pm Subject: Is this the way this SQL is required? |
Thank You Bithead, for you kind reply . |
Topic: Is this the way this SQL is required? |
Arun
Replies: 3
Views: 2346
|
Forum: Database Posted: Wed May 28, 2003 5:02 pm Subject: Is this the way this SQL is required? |
Hi,
One of our production maintenance job has a sysin that has both the queries below. I'm just confused. Why should they have both of the queries in a single sysin ? I don't see any point ... |
Topic: ABEND=S0C6 U0000 REASON=00000006 - any hint ?? |
Arun
Replies: 0
Views: 3333
|
Forum: Problem Determination Posted: Mon May 26, 2003 5:51 pm Subject: ABEND=S0C6 U0000 REASON=00000006 - any hint ?? |
Hi,
One of my production job had an abend ABEND=S0C6 U0000 REASON=00000006.
In the dump analysis, i found the abend happened at one address where there is a variable declaration, I know there ... |
Topic: To check the status of Tablespace |
Arun
Replies: 2
Views: 2444
|
Forum: Database Posted: Wed May 21, 2003 12:32 pm Subject: To check the status of Tablespace |
It worked.
Thank You very much |
Topic: To check the status of Tablespace |
Arun
Replies: 2
Views: 2444
|
Forum: Database Posted: Tue May 20, 2003 1:11 pm Subject: To check the status of Tablespace |
Hi all,
Is there any way i can check the status (Check Pending, Copy Pending etc) of the DB2 table space directly using BMC.
My jobs are abending 'coz some of my tables are in Check/Copy p ... |
Topic: SYSTEM COMPLETION CODE=7FC REASON CODE=00000004 |
Arun
Replies: 6
Views: 6501
|
Forum: Database Posted: Tue May 20, 2003 1:03 pm Subject: SYSTEM COMPLETION CODE=7FC REASON CODE=00000004 |
You are right bablack.
File as per definition, it has to write to disk, but for some reason, the SMG group, started pointing that to the Tape. Thatz why it was writing to tape, though it is defi ... |
Topic: SYSTEM COMPLETION CODE=7FC REASON CODE=00000004 |
Arun
Replies: 6
Views: 6501
|
Forum: Database Posted: Tue May 20, 2003 10:16 am Subject: SYSTEM COMPLETION CODE=7FC REASON CODE=00000004 |
Thatz an excellent pointer bablack
I'm getting the following messages
"IEFTMS50 7XX- 04" and
"IEFTMS50 ***** CA-1 ABEND,EX,04 *****"
and i'm using a tape with 'MOD' disp and has the followi ... |
Topic: SYSTEM COMPLETION CODE=7FC REASON CODE=00000004 |
Arun
Replies: 6
Views: 6501
|
Forum: Database Posted: Mon May 19, 2003 10:54 am Subject: SYSTEM COMPLETION CODE=7FC REASON CODE=00000004 |
Hi all,
One of my DB2 job (which does REORG, RUNSTAT AND COPY TABLESPACE), is abending with the following return code
"SYSTEM COMPLETION CODE=7FC REASON CODE=00000004"
It has the fo ... |
Topic: ABEND=S04E REASON=00E40018 |
Arun
Replies: 4
Views: 39626
|
Forum: Database Posted: Wed Apr 02, 2003 12:09 pm Subject: ABEND=S04E REASON=00E40018 |
Thatz wonderful
It worked ..
Thank You Very much Kolusu |
Topic: ABEND=S04E REASON=00E40018 |
Arun
Replies: 4
Views: 39626
|
Forum: Database Posted: Wed Apr 02, 2003 9:35 am Subject: ABEND=S04E REASON=00E40018 |
Thank You Very Much Kolusu !
You are right, i was trying to restart the job with 'MOD' disp for the work files. Now i changed the disp to 'NEW' and i restarted the job with UTPROC='RESTART(PHASE)' ... |
Topic: ABEND=S04E REASON=00E40018 |
Arun
Replies: 4
Views: 39626
|
Forum: Database Posted: Tue Apr 01, 2003 10:58 pm Subject: ABEND=S04E REASON=00E40018 |
Hi all,
I'm getting an ABEND=S04E REASON=00E40018, when i'm trying to load data to a DB2 table using DSNUTILB. I have searched in the web, it gives me a pointer about corrupted index etc.
Can ... |
Topic: How to edit a load module ? |
Arun
Replies: 1
Views: 2074
|
Forum: Application Programming Posted: Mon Mar 24, 2003 5:53 pm Subject: How to edit a load module ? |
Hi,
Is there any way that i can edit the load module.? For example (i.e) i have to copy the load module test1 as test2 and edit the test2 module to change the name of the program from test1 to tes ... |
|