How to monitor table reorgs with db2pd -reorgs

The following command can be used to view the reorganization flags for the tables and the indices of the tables: Db2 connect to MYDB db2 reorgchk current statistics on table all This is a basic readout and reports on every table. In practise, I just need to view the recent table reorg stats. Fortunately the db2pd utility returns this information. The basic command is db2pd –reorgs index Read more about db2pd in the db2pd troubleshooting guide - DBA DB2 The command gives you detailed information about table and index reorganisation. Three panels of information appear: Table Reorg Information - Table... Read more →

How to use DB2 COUNT_BIG

Question: How is the function COUNT_BIG() used and what is the difference with COUNT()? Answer: Both COUNT(*) and COUNT_BIG(*) return total number of rows in a table where the value of the column is NOT NULL. The difference is COUNT(*) returns INT datatype and COUNT_BIG(* ) uses the bigint datatype When to use COUNT_BIG? If you think the result count is greater than the maximum value of integer Read more on data types DB2 enforcing business rules on data - DBA DB2 - DBA-DB2.com DB2 Database objects overviews - DBA DB2 How to use large BLOB/CLOB in HADR - DBA... Read more →