AnsweredAssumed Answered

CA IDMS V18.5 - Restructure Error Status 0520

Question asked by fadge03 Employee on Oct 30, 2013
Latest reply on Nov 13, 2013 by Dick.Weiland

Hi,

A client is converting from a chained set to user-owned index set using CA IDMS V18.5. Execution of Restructure utility got an error status 0520. Print Page from DBKEY in error does not show any error in the contents of pointers (Next, prior or owner). The sequence of records in the SET are ok in any direction. The set has two members only. (Owner SEGRB001 Member SEGRB010).

DBkey in error (93452:267) is the content of SEGRB010 record.

  RESTRUCTURE SEGMENT SEG01 USING SEGSUB01 RSTTMOD IDMSRSTT ;
 UT000038 Starting Restructure of area SEG01.SEG-DEMO-AREA
 UT000027 DB error processing record SEGRB001.  Errstat=0520  Dbkey=93452:267  Err Dbkey=93452:267
 Status = -5       SQLSTATE = 60003        Messages follow:
 DB001031 C-4M365: DB error 0520; Tbl:SEGRB010, Area:SEG-DEMO-AREA
          ErrSet:?, ErrTbl:SEGRB001, ErrArea:?
 DB001068 C-5M327: Unable to rollback database changes

Before Restruct run, IDMSDBAN ran without errors using the same subschema.

Print Page (Next and Prior Pointer of record SEGRB001 are positions 20 and 21) (Next, Prior and owner of record SEGRB010 are positions 1, 2, and 3)

- 1,001    544   265  5C24  7,751,817-001  7,751,817-001  7,751,817-001
                                                93,452-280       93,452-280        **,***,***-***
                                          7,370,452-005        93,452-265       93,452-265
                                                93,452-265       93,452-265       93,452-265
                                                93,452-265       93,452-268       93,452-277
                                                93,452-278       93,452-279  1,304,920-095
                                           1,304,920-147       93,452-266       93,452-267
                                                93,452-265       93,452-265  7,481,153-069
                                           7,481,153-069   7,369,703-001       **,***,***-***
                                           8,096,729-104   8,096,729-104      93,452-265
                                                93,452-265         **,***,***-***  8,140,511-024
                                                93,452-265        93,452-265  8,140,511-024
                                           8,140,511-024    7,398,758-001 1,304,920-096
-                                          1,304,920-146         93,452-265      93,452-265
                            *01005510500008212030055005501300614793500000000000*
                            *05193040000000000005193042803851211300044400002400*
                            *28038728078528118500000000000000000000000000000000*
                            *00002809850000000053120885017000000000000418819000*
                            *000000007281085185032828088500070126..........0527*
                            *10850000000000160600000000028038500000000000000000*
                            *000000000000000000000000000000003110850...000D1200*
                            *0000 000000000000000000000000140570000000000000   *
                            *   00000000        000000000000000000000000150885F*
                            *N010000000000000000000000000000 0000000000........*
                            *....                                        *
- 1,010     28   266  5EEC     93,452-267     93,452-265     93,452-265                              
                            *26000000000000000195458000  *
- 1,010     28   267  5F14     93,452-265     93,452-266     93,452-265
                            *23010485000000000000000000..*

Any consistent suggestion about error status 0520 ??

Tks.

Outcomes