Have you ever run the db2 [call get_dbsize_info(?,?,?,0)] command to get the size of your DB2 LUW database and noticed that the size is much smaller than the space used on your UNIX ...
format of a date when performing a select in an application or the command center
A set of panels and batch jobs that will report changes in access path selection based on the data in the plan table. Panels will show package SQL and support the creation of HINTS. ...
"DB2 in the Big Data World" Have you been hearing all the talk around big data?: Are you concerned that hadoop is flavour of the month, and the general principles of database management ...
The script Drive_RunstatScript.cmd will control the execution of the ps1 members, the parameter labelled "ameddev" is my database name, so replace that with your database name. Also ...
DB2 Row Numbers for Z/OS, OS/390 (Versions 6, 7, and 8)
DB2 Subsystem Menu: REXX code and panel to extract, display and select a defined DB2 subsystem. A subsiduary command (provided as part of the calling sequence) is invoked with the name ...
If you have application jobs or users that run the DB2 load utility and would like to keep track of this information over time there is valuable information stored in the DB2 diagnostic ...
Hi! I cobbled together a little SQL to create a cross-reference of all DB2 tablespace, tables and indexes with key columns, uniqueness etc. I use it all the time and I finally ...
DB2ClearOS - The All in One DB2 Express-C Web Stack Appliance. Watch the Promo Video below - HD recommended http://www.youtube.com/watch?v=BxbHjEo7Rp8&hd=1 Download the ...