IT15878: DROPPING AN SBSPACE WHILE LEVEL 0 BACKUP IS RUNNING FAILS BUT LEAVES SBSPACE WITH NO USER DATA SPACE REFERENCE IN SHARED MEMORY

APAR status

• Closed as program error.

Error description

• If an onspaces -d is run on an sbspace while a L0 backup is
  running it returns the error:
  
  =>onspaces -d sbsp1 -y
  Cannot drop the Space.
  ISAM error: archive in progress
  
  It then leaves the sbspace in a state that will cause backup to
  fail with:
  
  12:51:23  ARCHIVE ERROR: Failure in sbx_arc_uelists_bld: sberrno
  = 12143 sbsnum = 4
  
  It also shows -1 for free and bpages in onstat -d:
  
  address          chunk/dbs     offset     size       free
  bpages     flags pathname
  4e476028         4      4      0          512000     -1
  -1         POSB-- /data1/dkolbin/sbsp1
  

Local fix

• Bouncing the engine resolves the issue.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users trying to drop an sbspace during an archive.           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC8                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC8
  

Temporary fix

Comments

APAR Information

• 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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP