IBM Support

IC71619: UPGRADING FROM 9.40 TO 11.50.XC7W1 FAILS WITH PTHDRPAGE:PTALTSTAT2:BAD ALTER SLOT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • 3 user tables failed with pthdrpage:ptaltstat2:bad alter slot
    after upgrading from 9.40.FC8 to 11.50.FC7W1.
    
    Oncheck -cID/-cc in IDS 9.40.FC8 comes back clean. Recreating
    the table in IDS 9.40.FC8 fixes the problem.
    
    Problem reproduced using onunload binary.
    
    online.log:
    12:12:34  Conv/rev: Finished conversion for component HA
    12:12:34  Conversion Completed Successfully
    12:12:34  On-Line Mode
    12:12:34  Building 'sysadmin' database ...
    12:12:34  Checkpoint Completed:  duration was 0 seconds.
    12:12:34  Wed Sep 15 - loguniq 155414, logpos 0xa3e720,
    timestamp: 0x3575e2a Interval: 23
    
    12:12:34  Maximum server connections 3
    12:12:34  Checkpoint Statistics - Avg. Txn Block Time 0.001, #
    Txns blocked 0, Plog used 11355, Llog used 481
    
    12:12:34  The restore point ended and related data in directory
    /app/informix/tmp/1 were removed.
    12:12:39  Unloading Module <SPLNULL>
    12:12:40  Loading Module <SPLNULL>
    12:12:41  Unloading Module <SPLNULL>
    12:12:41  Loading Module <SPLNULL>
    12:12:42  Unloading Module <SPLNULL>
    12:12:42  Loading Module <SPLNULL>
    12:12:42  'sysadmin' database built successfully.
    12:12:42  SCHAPI: Started dbScheduler thread.
    12:12:42  SCHAPI: Started 2 dbWorker threads.
    12:12:42  Checkpoint Completed:  duration was 1 seconds.
    12:12:42  Wed Sep 15 - loguniq 155414, logpos 0x12f0504,
    timestamp: 0x35807b7 Interval: 24
    
    12:12:42  Maximum server connections 3
    12:12:42  Checkpoint Statistics - Avg. Txn Block Time 0.000, #
    Txns blocked 2, Plog used 2635, Llog used 2284
    
    12:21:09  Checkpoint Completed:  duration was 1 seconds.
    12:21:09  Wed Sep 15 - loguniq 155414, logpos 0x99eb1fc,
    timestamp: 0x36f5295 Interval: 25
    
    12:21:09  Maximum server connections 3
    12:21:09  Checkpoint Statistics - Avg. Txn Block Time 0.000, #
    Txns blocked 1, Plog used 196627, Llog used 34574
    
    12:24:59  Logical Log 155414 Complete, timestamp: 0x3778a68.
    12:25:00  Logical Log 155414 - Backup Started
    12:28:15  HPUX KAIO Segment locked addr=0x54c11000
    size=536870912
    12:28:15  HPUX KAIO Segment locked addr=0x54c11000
    size=536870912
    12:28:15  HPUX KAIO Segment locked addr=0x54c11000
    size=536870912
    12:28:15  Dynamically allocated new virtual shared memory
    segment (size 524288KB)
    12:28:15  Memory sizes:resident:318980 KB, virtual:1573520 KB,
    no SHMTOTAL limit
    12:28:34  Logical Log 155414 - Backup Completed
    12:29:46  Assert Failed: pthdrpage:ptaltstat2:bad alter slot
    12:29:46  IBM Informix Dynamic Server Version 11.50.FC7W1
    12:29:46   Who: Session(143, informix@, 0, c000000015a08a68)
      Thread(167, dbWorker2, c0000000159cd188, 3)
      File: rspartn.c Line: 7217
    12:29:46   Results: Cannot use TBLSpace page for TBLSpace
    2275275
    12:29:46   Action: Run 'oncheck -pt 2275275'
    12:29:46  stack trace for pid 23604 written to
    /var/tmp/af.48f4bb9
    12:29:47   See Also: /var/tmp/af.48f4bb9
    
    Example AF stack trace:
    12:29:46  IBM Informix Dynamic Server Version 11.50.FC7W1
    Software Serial Number AAA#B000000
    
    12:29:46  Assert Failed: pthdrpage:ptaltstat2:bad alter slot
    12:29:46   Who: Session(143, informix@, 0, c000000015a08a68)
      Thread(167, dbWorker2, c0000000159cd188, 3)
      File: rspartn.c Line: 7217
    12:29:46   Results: Cannot use TBLSpace page for TBLSpace
    2275275
    12:29:46   Action: Run 'oncheck -pt 2275275'
    12:29:46  Raw hex dump of stack located in
    /var/tmp/af.48f4bb9.rawstk
    12:29:46  Stack for thread: 167 dbWorker2
    
     base: 0xc000000017850000
      len:   135168
       pc: 0x0000000000000000
      tos: 0xc000000017855780
    state: running
       vp: 3
    
    ( 0)  legacy_hp_afstack
    ( 1)  afstack
    ( 2)  afhandler
    ( 3)  affail_interface
    ( 4)  pthdrgetx
    ( 5)  ptaltstat
    ( 6)  ptalloc
    ( 7)  nxtpartp
    ( 8)  prptnhdr
    ( 9)  pstread
    (10)  pst_rsread
    (11)  rsread
    (12)  fmread
    (13)  readseq_single
    (14)  readseq
    (15)  gettupl
    (16)  scan_next
    (17)  join_next
    (18)  getrow
    (19)  fetchrow
    (20)  ip_scurnext
    (21)  ip_evalcurnext
    (22)  runproc
    (23)  udrlm_spl_execute
    (24)  udrlm_exec_routine
    (25)  udr_execute
    (26)  mi_routine_exec
    (27)  ph_exec_func
    (28)  ph_execute
    (29)  do_sensor
    (30)  db_sch_worker
    (31)  udrlm_clang_execute_internal
    (32)  udrlm_clang_execute
    (33)  udrlm_exec_routine
    (34)  udr_execute
    (35)  dbsched_start_udr
    (36)  startup
    (37)  resume
    
     base: 0xc000000017850000
      len:   135168
       pc: 0x0000000000000000
      tos: 0xc000000017855780
    state: running
       vp: 3
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users migrating from versions older than 10x to newer        *
    * versions with alter versions spanning more than 2 pages      *
    * could hit this problem.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When converting from 9.4x to 11.50 versions, engine did not  *
    * delete the unused secondary header pages containing alter    *
    * versions. This caused the subsequent select statement to     *
    * refer to these pages and caused the problem.                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDS 11.50.xC8.                                    *
    ****************************************************************
    

Problem conclusion

  • The workaround for this problem is remove all the pending alters
    before migrating. The other way is to upgrade to IDS 11.50.xC8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC71619

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-09-30

  • Closed date

    2011-01-20

  • Last modified date

    2011-01-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 January 2011