IT46749: LOCAL STGPOOL PROTECTION PRODUCES MANY "COLUMN 7 IN TABLE UNKNOWN IS NULL" MESSAGES IN DSMFFDC.LOG

8.1.25.000-IBM-SPSRV-WindowsX64-340
8.1.25.000-IBM-SPSRV-Linuxx86_64-340
8.1.25.000-IBM-SPSRV-Linuxs390x-340
8.1.25.000-IBM-SPSRV-Linuxppc64le-340
8.1.25.000-IBM-SPSRV-AIX-340

APAR status

• Closed as program error.

Error description

• After 'protect stgpool type=local' starts, large amounts of the
  following messages appear in dsmffdc.log.
  [xx-xx-xxxx xx:xx:xx.xxx][ FFDC_GENERAL_SERVER_ERROR ]:
  [xxx](sdprotect.c:16909)(PROCESS: xxx, SESSION: xxx) Column 7 in
  table UNKNOWN is NULL.
  
  If 'reclaim=only/onlylimited' is specified, the message will not
  be generated.
  

Local fix

• Set the option:
  setopt sdLocalProtNewBatchNDChunksSQL true
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Storage Protect server users.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Apply fixing level when available. This problem is currently
  projected to be fixed in level 8.1.25. Note that this is subject
  to change at the discretion of IBM.
  

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

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels