Follow me !
Search this blog
-
Recent posts
Tags
AIX Apple automation backup best practices Bootcamp cloud cursor db2 db2 compression db2 hadr db2 performance db2 tuning db2 v9.5 db2 v9.7 db2move db2pd google indexes install iPad iPhone linux Macbook memory NULLID Oracle package performance restore runstats script shell script sql SQL805N SQL Server stored procedure tablespace time machine tuning ubuntu ubuntu 9.04 upgrade Windows on Mac wordpressDisclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Category Archives: how to
Checking on HADR
By now I am sure lot of db2 users have adopted DB2 HADR as one of their high availability solution. IBM has matured HADR over the last two versions and its becoming more and more robust. Couple of years ago … Continue reading
Posted in database, db2, how to
Tagged check hadr, db2 hadr, db2 high availability, db2pd, hadr, hadr status
1 Comment
A quick overview of DB2′s INGEST
As a DB2 DBA or as data integrator we all face a challenge in loading large amount of data into DB2 database while up keeping the 24×7 availability of the tables. Traditionally we use LOAD or sometimes IMPORT while loading … Continue reading
DB2 V10 Adaptive Compression
Last February, I wrote about DB2′s compression. If that was McLaren, with DB2 V9.7′s compression, IBM upgraded to Lamborghini Aventador. Apparently IBM’s thirst didn’t stop there, they went one more step ahead and got the Bugatti Veyron with DB2 V10′s … Continue reading
Posted in db2, how to
Tagged adaptive compression, adc, admintabinfo, admin_get_index_compress_info, admin_get_tab_compress_info, admin_get_tab_info, automatic dictionary creation, classic compression, compress yes, database compression, db2 compression, db2 performance, db2 tuning, db2 udb, db2 v10 compression, deep compression, performance, resetdictionary, row compression
Leave a comment
ADMIN_MOVE_TABLE
Have you ever had to move a table from one tablespace to another ? If you haven’t then you haven’t been working with lot of large tables. Ask a dba who supports SAP, Siebel or PeopleSoft database. Traditionally when a … Continue reading