Search results for query: *

Hi, I have a batch records to insert into table. One of the column is blob, so I have to use setBinaryStream. But if I use addBatch to insert a batch records, it not work. It return array of int, e.g if I insert 2 record, it return int[2], and the value of array is 65537, what that mean...

Hi Matchum, thank you very much for your help to let me understand the db2 backup and restore.

Actually I just want to understand what is the different btw incremental or incremental delta, and when I need to use it. I'm quite confuse with these 2 type of backup.

Hi Matchum, Thank you for your help. Follow your instruction, I finally restore the database into a new system. Like u said, thats 2 pieces of cake!! Now, I'm confused with backup command with incremental and incremental delta parameter. Delta is non-cummulative and without delta is...

Thank you matchum. For example, if I'm not using TSM, can you tell me which log I need to copy to my CD? Is it the one in the Log Location Path set in the Configuration? After that, can you tell me how to restore the database to a new System.(Imagine that the database system is crash, and I...

I can do the backup now, cos I change it to SUSE IBM Database. Previously, I was using redhat with a try version of DB2 from IBM. I have 2 question to ask you. In the Data Recovery and High Availability Guide and Reference Book from IBM. There is an example to do backup. The example is like...

I check the log directory, they are 3 log files in there, and they are not a text file. Sometimes, when I enter this command "backup db payroll to /tmp/PAYROLLBACKUP" then it give me this error message: SQL2044N An error occurred while accessing a message queue. Reason...

Hi DB2 Guru, I'm new in DB2. Can someone please give me some tips how to do a backup in DB2 database. I create the backup from the backup wizard, when I run it, it always failed. The error message is "SQL0902C A system error (reason code="") occurred. Subsequent SQL...