Release Notes (version 8.1.2)

1Development Center now supports Actual Cost information for SQL statements run on OS/390 or z/OS servers

1The DB2 Development Center now provides Actual Cost information for SQL 1statements run on DB2 Version 6 and Version 7 OS/390 and z/OS servers. 1The following Actual Cost information is provided: 1

• 1CPU time
• 1CPU time in external format
• 1CPU time as an integer in hundredths of a second
• 1Latch/lock contention wait time in external format
• 1Number of getpages in integer format
• 1Number of read i/o in integer format
• 1Number of write i/o in integer format 1

1This functionality also allows you to view multiple sets of Actual Cost 1results for a single SQL statement with different host variable values.

1Actual Cost information is available in the Development Center from the 1Create SQL Stored Procedure and Create Java Stored Procedure wizards, within 1the SQL Statement window for OS/390 and z/OS connections. To use the 1Actual Cost functionality , click the Actual Cost button in the 1OS/390 and z/OS connection window in either of the Stored Procedure 1wizards. You must have the Stored Procedure Monitor Program (DSNWSPM ) 1installed on your DB2 OS/390 server to use Actual Cost 1functionality.