by Vikram Khatri | Aug 30, 2007
Did you get this DB2 SQL1035N error if you were trying to take offline backup? The error is obvious as someone is connected to the database and you cannot take offline database backup. There are several solution that you can take to do offline backup when you get SQL...
by Vikram Khatri | Aug 29, 2007
Did somebody create a DB2 database for you and you are just getting started to work on inherited legacy? How do you find if the database was created with automatic storage YES or NO? Let us do a simple exercise. My laptop has two drives C: and D: and I have DB2 9...
by Vikram Khatri | Aug 9, 2007
Did you ever wonder what is cursor blocking or row blocking in DB2? Cursor or Row blocking in DB2 is a way to fetch number of rows in a single operation. This can improve performance of the applications. There are 3 types of blocking which can be used for your...
