PM64949: UNSUPPORTED DBSU FUNCTIONS WHEN BEING CALLED FROM AN APPLICATION PROGRAM.

APAR status

• Closed as documentation error.

Error description

• Documenting DBSU functions not supported when DBSU is being
  called by an application program.
  
  // EXEC PGM=COBDBSU,SIZE=AUTO
  
  1S54I  PHASE COBDBSU  IS TO BE FETCHED FROM USER.USR1
  ARI0801I DBS Utility started: 25/08/11 14:30:15.
           AUTOCOMMIT = OFF ERRORMODE = OFF
           ISOLATION LEVEL = REPEATABLE READ
  ------> CONNECT "SQLDBA  " IDENTIFIED BY ********;
  ARI8004I User SQLDBA connected to server SQLDS.
  ARI0500I SQL processing was successful.
  ARI0505I SQLCODE = 0 SQLSTATE = 00000 ROWCOUNT = 0
  ARI0808I DBS processing completed: 25/08/11 14:30:15
  ARI0801I DBS Utility started: 25/08/11 14:30:15.
           AUTOCOMMIT = OFF ERRORMODE = OFF
           ISOLATION LEVEL = REPEATABLE READ
  ARI8999E Invalid SQL statement or parameter: UNLOAD
  DBSPACE(SAMPL
  ARI8998I ...Begin ROLLBACK processing.
  ARI0811I ...ROLLBACK of any database changes successful.
  ARI0813I ...Suspend command execution:
           AUTOCOMMIT = OFF ERRORMODE = ON
  ARI0808I DBS processing completed: 25/08/11 14:30:15.
  1S55I  LAST RETURN CODE WAS 0008
  EOJ COBDBSUJ  MAX.RETURN CODE=0008
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL DB2 SERVER FOR VSE USERS                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: WHEN DBSU IS BEING CALLED BY AN         *
  *                      APPLICATION PROGRAM, THE UNLOAD,        *
  *                      DATAUNLOAD, RELOAD, AND DATALOAD        *
  *                      COMMANDS ARE NOT BEING SUPPORTED.       *
  ****************************************************************
  * RECOMMENDATION: UPDATE THE SPECIFIED MANUAL.                 *
  ****************************************************************
  WHEN DBSU IS BEING CALLED BY AN APPLICATION PROGRAM, THE
  UNLOAD, DATAUNLOAD, RELOAD, AND DATALOAD COMMANDS ARE
  NOT BEING SUPPORTED.
  

Problem conclusion

• THE FOLLOWING SECTIONS IN THE DB2 SERVER FOR VSE SYSTEM
  DATABASE SERVICES UTILITY VERSION 7 RELEASE 5 MANUAL
  (SC09-2983-03) WILL HAVE TO BE CHANGED:
  
  1)ON PAGE 112, CHANGE:
  
  USING THE DATABASE SERVICES UTILITY FROM PROGRAMMING LANGUAGES
  
  YOU CAN INVOKE THE DATABASE SERVICES UTILITY PROGRAM FROM AN
  ASSEMBLER LANGUAGE, PL/I, C, OR COBOL PROGRAM BY USING THE
  DATABASE SERVICES UTILITY ENTRY POINT ARIDBS. (YOU CANNOT
  INVOKE THE DATABASE SERVICES UTILITY FROM A FORTRAN PROGRAM.)
  
  TO:
  
  USING THE DATABASE SERVICES UTILITY FROM PROGRAMMING LANGUAGES
  
  YOU CAN INVOKE THE DATABASE SERVICES UTILITY PROGRAM FROM AN
  ASSEMBLER LANGUAGE, PL/I, C, OR COBOL PROGRAM BY USING THE
  DATABASE SERVICES UTILITY ENTRY POINT ARIDBS. (YOU CANNOT
  INVOKE THE DATABASE SERVICES UTILITY FROM A FORTRAN PROGRAM.)
  
  WHEN DBSU IS BEING CALLED FROM AN APPLICATION PROGRAM, THE
  UNLOAD, DATAUNLOAD, RELOAD, AND DATALOAD COMMANDS ARE NOT
  BEING SUPPORTED.
  
  
  2)ON PAGE 124, IN FIGURE 69. SAMPLE COBOL PROGRAM TO CALL THE
  DATABASE SERVICES UTILITY CHANGE:
  
  /*
  INCLUDE ARIPRDID
  INCLUDE ARIPADR4
  INCLUDE ARISYSDD
  INCLUDE ARIDSQLA
  INCLUDE ARIDDFP
  INCLUDE ARITDSSD
  
  TO:
  
  /*
  INCLUDE ARIPRDID
  INCLUDE ARIPADR4
  INCLUDE ARISYSDD
  INCLUDE ARIDSQLA
  INCLUDE ARIDGLBD
  INCLUDE ARISYSED
  INCLUDE ARIDDFP
  INCLUDE ARITDSSD
  

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

Applicable component levels