IC74667: THE SYSDBCLOSE() PROCEDURE DOESN'T WORK CORRECTLY IF IT CONTAINS THE 'CURRENT' OPERATOR

APAR status

• Closed as program error.

Error description

• If you want to use the sysdbclose() procedure in your database
  and the body of this procedure utilizes the 'current' operator
  either to set some datetime variable or to insert a current
  datetime value into a column in some table, the procedure
  doesn't work correctly. It generates the errors -1266 or -1263
  internally and fails silently (you could check the error in a
  trace file generated when the 'SET DEBUG FILE TO ...' and 'TRACE
  ON' commands are used in the procedure body).
  Depending on where in the procedure body is the 'current'
  operator used the procedure might do some work before it fails.
  

Local fix

• Use the following combination of 'extend' and 'dbinfo' functions
  instead of the 'current' operator:
  EXTEND(DBINFO('utc_to_datetime',dbinfo('utc_current')),
  datetime_qualifier )
  
  for example:
  EXTEND(DBINFO('utc_to_datetime',dbinfo('utc_current')), YEAR TO
  SECOND)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This problem is platform independent.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Using current operator in sysdbclose( ) does not work as     *
  * expected when client terminates session without an explicit  *
  * 'close database'.                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC9.                                        *
  ****************************************************************
  

Problem conclusion

• Fixed in 11.50.xC9.  The current operator in sysdbclose( ) will
  work as expected with this fix whether explicit close database
  is present or not.
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP