DB2

Restoring the event monitor file
$db2evmon -db DEV1926 -evm DB2DETAILDEADLOCK was showing data from all the runs whereas i want the data just for a single run. To capture fresh events, I deleted the old events file. caveat was, I deleted this event file while DB2DETAILDEADLOCK was still active (state 1). now when i Try to run the db2evmon comm... 5 Aug 2007 01:13

Error activating a database/cannot allocate agent
Hi there, I previously posted this to the DB2-Express-C forum at ibm.com, but this group seems to get more traffic so I've reposted it here. The previous (off-group) post is at the URL below and unless anyone can't access it I won't repost the attachments inline here. http://www-128.ibm.com/developerworks/foru... 26 Jul 2007 12:51

DB2 Express-C on Windows XP SP2 "Invalid parameter number. SQLSTATE=S1093"
I'm getting error "Invalid parameter number. SQLSTATE=S1093" when I attempt to ADD or modify rows within the Control Center (open table option). However, using the command editor within Control Center to run SQL statements works perfectly. Since I'm in the same user context for both operations, that eliminates se... 19 Jul 2007 13:24

SQL0332N There is no available conversion for the source code page
Hi All, I've got 2 db2 udb 8.2 databases. One is code page 1208, the other 819. With my LANG=C, I can't connect to the 1208 db. With my LANG=en_US.UFT-8 I can't connect to the 819 db. But sqllib/conv/12080819.cnv is there. Why can't it translate? Thank you. Sincerely, George ... 13 Jul 2007 16:03

LOAD and LOAD with AMDIN_CMD
Hi! I've tried LOAD .... INSERT INTO TABLE_NAME. The docs say about INSERT option: "One of four modes under which the load utility can execute. Adds the loaded data to the table without changing the existing table data." But when I do LOAD I get this in my message file: Number of rows read = 671 Numb... 7 Aug 2007 08:08

Run DB2CMD commands through PowerShell
Does anyone have an idea what it takes to administer DB2 through PowerShell? I want to write some scripts to automate my common DB2 management tasks and I'd really like to be able to use PowerShell for that scripting, but I can't find a way to run DB2 comands. I've tried db2cmd /w db2cmd /w /i db2cmd /i (this... 15 Jul 2007 21:38

message in db2diag.log
hi all! 2006-09-06-22.01.34.183570+540 I5679485A498 LEVEL: Error PID : 655366 TID : 1 PROC : db2agent (AMISDB) 0 INSTANCE: amisinst NODE : 000 DB : AMISDB APPHDL : 0-553 APPID: AC1F205E.J009.01B346130038 FUNCTION: DB2 UDB, database monitor, ... 6 Jul 2007 05:00

DB Backup error
When backing up a group of DB2 WSE v8.2 databases, I am getting the following error on one or two backups out of 38 being performed. "SQL2025N An I/O error "200" occurred on media <target directory path>". The backups run every night. This error appears about two times a week. This process is backing up database... 3 Jul 2007 17:04

Migration from V8(solaris) to V9(redhat)
Hello: We are trying to migrate DB2 Source: DB2 8.1 + Fixed Pack 5 on Sun Solaris -> Target: DB2 9.X on Red Hat Linux . using db2move command we are trying out the migration. However one of the tables contains blob and clob data. What is teh correct way to move such a table? Here's the error we get. Any help is ... 29 Jun 2007 08:19

Can Not Create Database - DAS Is Not Active
I install the UDB Ver 8.2 FixPack 9 on HP Proliant Server running RHEL 4 and Java Version is 1.4.2. After install, i try to create new database. i got error "SQL22204N The DB2 Administration Server encountered a non- severe error while executing a request..." and if i try to create again after that error message... 20 Jun 2007 23:51