Software unit testing and DB2 sql loop test code

Software unit testing is normally a formalised approach to test code and system implementations. DB2 sql loop test is sometimes requested by developers to the DB2 DBA . This code is a stored procedure the DB2 DBA can set up and test . The code creates a table : “test” and a stored procedure : “sum_mn” An example execute of the code as :call sum_mn 1,1000,? This starts from 1 loops through to 1000 and adding at every loop #############CODE START############################### CREATE TABLE test (num INT); CREATE PROCEDURE sum_mn (IN p_start INT ,IN p_end INT ,OUT p_sum INT) SPECIFIC sum_mn... Read more →

DB2 9 Fundamentals Certification

DB2 9 Fundamentals Certification is completed.After a few years of avoidance , I decided to attain some DB2 certifications. I’d always placed greater emphasis on self study and experience. But having completed the first certification, I was pleasantly surprised about the level of detail required to do well. After some initial research – I decided upon the relevant path for certification as DBA for LUW. This involved : IBM Certified Database Associate (DB2 Fundamentals) (Exam 730) IBM Certified Database Administrator (Exam 731) IBM Certified Advanced Database Administrator (Exam 734) I purchased a book – DB2 9 Fundamentals by Roger E.... Read more →

Data Center Migration , Database Servers and data migration planning

Data Center Migration , Database Servers and data migration planning is critical to a successful migration. Enterprise architects tend to categorise database servers part of the shared services layer. I’ve been involved in a few very large Data Center migrations as the Senior DBA for DB2 and SQL Server inventories – and developed an approach suited to minimising risks. Not all risks disappear. But with a structured approach – at least you can feel comfortable most bases are covered. Some general data center migration principles 1)DO NOT make any design changes as part of the migration. For example , if... Read more →

Database size in DB2

How can I calculate the Database size in DB2? Database size in DB2 - Find 3 methods I use to find the database size in DB2 METHOD 1 - GET_DBSIZE_INFO ============================ db2 connect to db2 "CALL GET_DBSIZE_INFO (?, ?, ?, -1)" METHOD 2a (in MB) snapshot_tbs_cfg =============================== db2 connect to db2 "select (sum(total_pages)* 4096)/(1024*1024) Tot_allocat_spceinMB from table(snapshot_tbs_cfg(' ',-1)) TBS_SPCE" METHOD 2b (in GB)snapshot_tbs_cfg ================================== db2 "select (SUM(total_pages)*4)/(1024.0*1024) TOTAL_ALLOCATED_SPACE_IN_GB from table (snapshot_tbs_cfg('',-1)) TBS_SPCE" db2 connect reset METHOD 3 systools.stmg_dbsize_info ================================ SELECT db_size, db_capacity FROM systools.stmg_dbsize_info; Read More DB2 table size shell script - DBA DB2 Database will come up with hidden... Read more →

Advice for IT consultants

IT consultants are experiencing increased demand but more competition. An interesting article in The Economist – titled “Advice for consultants” on June 2nd 2011, offers some advice , similar to my experiences in the Database server and IT consultants market over the last couple of years. Demand for consultants increased since 2009 The first point they raise is demand for consultants increased since 2009. Companies are hiring consultants to assist in growth oriented activities , whereas in 2009 the focus was cost-cutting. Merging systems and technology platform roll outs. In some ways this remains accurate. Large companies are investing in... Read more →