DB2 – COPY a table

Different methods of extracting DDL and moving data. Use according to the situation 1) Gives you the table CREATE statements db2look -d DBNAME -e -t TABNAME 2) Use the DB2 Control Center to copy table and data 3) Use the CREATE … LIKE for the table structure CREATE TABLE LIKE Follow up with INSERT INTO TAB1 (SELECT * FROM TAB2) See Also db2move to copy data between databases Read more →

Storage Monitoring : a quick guide

Storage Monitoring requires an end to end view. Consider the different types of drives and servers connecting to the sub storage system Monitor – Hard Drives Controllers (CPU,Caching ) Controller connectivity Network switch throughput HBA connectivity Network Fabric SAN storage monitoring is expensive and requires deep expertise to interpret. SAN Documentation is available by the vendors. Compatibility lists are available. Talk to the vendor about compatibility across all platforms. Ask them to justify their details and verify your own server hardware decisions Performance Reporting. How relevant is yesterdays performance report? Data moves around fast , with new applications, company acquisitions... Read more →

POC

The usual Proof of Concept (POC) is : a) a new data centre build b) a new SAN ,SVC , or any other aspect of the substorage system c) new hardware d) new virtualized environment As the DBA you’ll be asked to validate these new systems. Why? 1) You’re responsible for the operational and performance SLAs of the Database servers. 2) Database servers tend to be IO intensive and require storage tuning, which means they must be tested on any new system for acceptance. A POC can become political . Different managers have already made decisions. It’s not uncommon for... Read more →

Data centre management for database servers

Setting up a new database server environment in a new data centre requires testing. It’s a mix of benchmarking and stress testing . Unless you can recreate the underlying traffic and recreate a “realistic” production environment , then it’s not strict benchmarking . The main purpose is to validate the storage and server layer. Another purpose is to test upgraded software and hardware. I specify more complicated tests if there is a requirement . In very large migrations , I take a risk based approach – which means I’ll identify a selection of database servers to test. The basic approach... 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 →