PP40685: DSNIDALC-VRACE5003-RC00C90101-DOING A UTILITY LOAD.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• *** APAR IN ERROR. SEE PP49871 FOR ERROR DESCRIPTION. ***
  ABEND04E RC00C90101 IN DSNIDALC VRACE5003 DOING A LOAD UTILITY.
  THE CONSOLE LOG SHOWS THE LOAD STARTING BUT NO MESSAGES AFTER
  THAT. IN DSNIDALC FOR VRACE5003 WE CHECK THE READ AND WRITE
  BUFFER INTENT COUNT TO MAKE SURE THAT THEY ARE ZEROS, AND IF
  NOT, THEN WE ABEND.
  

Local fix

Problem summary

• FIX IN ERROR: SEE PP49871 FOR DESCRIPTION.
  ****************************************************************
  * USERS AFFECTED: DB2 LOAD UTILITY USERS.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90101 IN DSNIDALC         *
  *                      VRACE5003 DURING LOAD UTILITY IF        *
  *                      THE LOAD UTILITY ENCOUNTERS INVALID     *
  *                      INPUT DATA AND ISSUES MSGDSNU334I.      *
  ****************************************************************
  * RECOMMENDATION: DO NOT APPLY. SEE PP49871 FOR DESCRIPTION.   *
  ****************************************************************
  IF DURING THE PROCESS OF LOADING RECORDS, DSNURWBF ENCOUNTERS
  INVALID DATA (SUCH AS CHARACTER DATA FOR AN INTEGER COLUMN),
  UTILITIES WILL ISSUE MSGDSNU334I AND ABORT THE RECORDS LOADED
  SINCE THE LAST COMMIT. THE ABEND04E OCCURS BECAUSE DSNURWBF
  FORGETS TO TELL DATA MANAGER THAT THE LOAD IS ENDING BY
  CALLING DSNIELOD. THIS RESULTS IN PAGES NOT BEING RELEASED
  BACK TO BUFFER MANAGER AND SO THERE IS A NON-ZERO READ INTENT
  COUNT (INDICATING THAT DSNILPG DID MORE BUFFER MANAGER 'GET
  PAGES' THAN 'RELEASE PAGES'). THIS NON ZERO 'READ INTENT
  COUNT' IS FINALLY SEEN BY DSNIDALC WHO ABENDS WITH A READ
  INTENT COUNT OF 1. THE PAGE THAT HAS NOT BEEN RELEASED IS THE
  SPACE MAP PAGE (PAGE 000001) OF THE TABLESPACE.
  

Problem conclusion

• FIX IN ERROR: SEE PP49871 FOR DESCRIPTION.
  IF UTILITIES (DSNURWBF) EVERS SEES AN EXCEPTION CONDITION SUCH
  AS INVALID INPUT DATA, A CALL TO DSNIELOD WILL NOW BE MADE TO
  RELEASE ALL DATA MANAGER RESOURCES (SUCH AS PAGES) AQUIRED
  DURING THE LOAD. THUS, BY THE TIME DSNIDALC GETS CONTROL,
  THERE WILL NOT BE ANY OUTSTANDING PAGE COUNTS. DESPITE THE
  FACT THAT UTILITIES FORGOT TO 'END THE LOAD' AND THUS LEAVING
  PAGES UNRELEASED, DATA MANAGER SHOULD HAVE SEEN THESE PAGES
  AND RELEASED THEM ON BEHALF OF UTILITIES. THE RELEASING OF
  THESE PAGES SHOULD BE DONE IN EITHER  DSNICMT2 (START PHASE 2
  COMMIT) OR DSNICLCU (CLOSE ALL CUBS OPENED ON THE TABLESPACE).
  THIS IN FACT WAS DONE WITH THE EXCEPTION OF SPACE MAP PAGES
  AQUIRED DURING THE LOAD UTILITY. SO, EVEN THOUGH UTILITIES
  SHOULD END THE LOAD, THERE IS A PROBLEM IN DATA MANAGER THAT
  DOES NOT COMPLETELY CLEAN UP THE UTILITY MISTAKE. AS A RESULT,
  DSNICMT2 AND DSNICLCU HAVE ALSO BEEN CHANGED TO RELEASE SPACE
  MAP PAGES AQUIRED.
  

Temporary fix

Comments

• REPINNED RP85/10/04 ANSWR TO SHOW CHANGE TO SUMMARY PAGE 1.
   **** PE85/11/27 FIX IN ERROR. SEE APAR PP49871  FOR DESCRIPTION
  REPINNED RP85/11/27 TO ADD PE INFO.
  REPINNED RP85/11/27 ANSWR TO SHOW CHANGE TO SUBMITTER TEXT.
  ×**** PE85/12/06 FIX IN ERROR. SEE APAR PP49871  FOR DESCRIPTION
  

APAR Information

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

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

  UP57622

Modules/Macros

•    DSNICLCU DSNICMT2 DSNURWBF
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R102 PSY UP57622

     UP85/04/04 P DLLB F505

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.