Category Archives: DB2
Migrating Data to DB2 9.7 LUW
Problem You reached the limit or your unhappy with the performance or features of your database server, and you want to move to DB2. The transition can be simple with respect to your code, as it may be just a … Continue reading
IBM Security Tools
IBM has a comprehensive approach to encourage security by design. A free Red Book is available for developers: The IBM Redbook for Security in Development The home page for IBM’s main security testing tool is IBM Rational AppScan Share and … Continue reading
SPSS Tutorials
Problem You heard that SPSS can dramatically improve the efficiency of your data warehouse, reporting and data analytics processes. But how to get started? Solution Here are some links that will get you pretty far: SPSS Official Site SPSS lectures … Continue reading
DB2 9.7.2 Log files on Windows 7
Problem Since Windows Vista (that includes Windows 7), the place where programs store some of their information has changed. This makes finding the DB2 log files (equivalent of db2diag.log) more difficult. Solution The log files have moved under the directory … Continue reading
Create Explain Tables in DB2 9.7
Problem The explain tables allow to create access plans and visualize them. Before the explain feature of DB2 can be used, the EXPLAIN tables need to be generated. Solution To create the EXPLAIN tables, the following command needs to be … Continue reading
Compiling C code on Windows 7 for DB2 9.7 64bit
Problem The %DB2PATH%\SQLLIB\samples\c directory on windows contains many examples of C routines to extend DB2 or to work with DB2 from C programs. This article describes how to compile the sample code for 64 bit. Solution Set the environment (VC … Continue reading
DB2 9.7 Error: SQL1005N The database alias already exists
Problem When trying to restore a database from backup, you might get an SQL1005N “The database alias “dabase_name” already exists in either the local database directory or system database directory.” Solution $ export DB2NODE=0 $ db2 terminate DB20000I The TERMINATE … Continue reading
Netapp Automation for DB2 9.7 (or Oracle)
Problem You have one or more NetApp storage systems (F960 or later series), running Data ONTAP® 7G (or later). You would like to take advantage of the snapshot capabilities, to facilitate the database backup process. However, you don’t want to … Continue reading
DB2 Query Writing Best Practices
Problem Writing efficient SQL SELECTqueries for DB2 can be tricky. Some general SQL guidelines apply, and there are also specific practices that apply only to DB2. Solution Here is a list of tips you can use to write good SELECT … Continue reading
Installing DB2 Express C 9.5 on Mac OS X 10.6
OS X developers do not need to use a virtual machine any longer to be able to run DB2 in their favorite development environment. The latest version of DB2 9.5 available for download works on Snow Leopard (OS X 10.6). Continue reading