| View previous topic :: View next topic |
| Author |
Message |
sinduja
Beginner
Joined: 20 Jun 2005
Posts: 29
Topics: 14
|
 Posted: Mon Nov 29, 2010 7:42 am Post subject: Abed 04E - After Access(FORCE) |
 |
|
Hello All,
I am getting Abend 04E while trying to update a table with SPUFI.
I browsed the DBMaster job in SDSF and found the following explanation
| Code: |
DSNI013I -D1UA DSNIIDIS POTENTIALLY INCONSISTENT 523
DATA
REASON 00C90206
ERQUAL 5002
TYPE 00000302
NAME ZURE58 .SK1T05 .X'00000A69'
CONNECTION-ID=TSO
CORRELATION-ID=CHY6293
LUW-ID=CHZUR000.CHZAD1UA.C6F3FA17188D=0
DSNI013I -D1UA DSNIIDIS POTENTIALLY INCONSISTENT 524
DATA
REASON 00C90206
ERQUAL 5002
TYPE 00000303
NAME ZURE58 .XK1T0502.X'00000003'
CONNECTION-ID=TSO
CORRELATION-ID=CHY6293
LUW-ID=CHZUR000.CHZAD1UA.C6F3FA17188D=0
|
And reason code 00C90206 says inconsistent data.
The table was recently loaded. I also found that my teammate has used ACCESS(FORCE) command to start the DB. The table space was in RECP-REcovery pending status after the load.
Now the DB and TS status are RW. But the update against the table is not working.
Could ACCESS(FORCE) be the reason for this?
Can someone please suggest me a way to update the table?
Also will running reocery against the TS work now??
Thank you in Advance.
Regards,
Sinduja |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Mon Nov 29, 2010 11:45 am Post subject: |
|
|
sinduja,
You need to start over from the beginning. Reload the table once again and run check pending utility. Better yet , make the changes in the load file itself and re-load the table.
Access(FORCE) should ONLY be used when you are really certain about the data.
Kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
