DB2

Packages (Package "NULLID.SYSLH214 0X5359534C564C3031" was notfound.)
Jurgen Haan wrote: We're getting an error "SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002" On our production database. And as suspected, SYSLH214 is not in the packages catalog. Ok.. Publib tells me the following: Apparantly a large placeholder for held cursors. (... 21 Nov 2006 09:34

slow connection to DB2/LINUX 8.2.3
Hello, after installing DB2 V8.2.3 on OpenSuse 10.1 (in vmware) we have created a database instance with the restore command: db2 "restore database $OLD_DB user db2inst1 using db2inst1 from $BACKUP_DIRECTORY taken at $TS into $DB". We have activated the database but the first connection is still slow. db2 con... 17 Nov 2006 17:27

SQL error 805
we had this error while running the applicaiton on db2 v8.2 EE on windows, jcc driver is what we use SQL error 805 com.ibm.db2.jcc.b.SQLException: NULLID.SYSLH203 0X5359534C564C3031, based on my experience, there is no such package exist, so what would be the main resaon behind this? thank you ... 7 Nov 2006 10:39

DB2 and extended ASCII table
Hi! Does DB2 handle extended ASCII table? Example: VALUES(CHR(65)) => A VALUES(CHR(129)) => null, but according to www.asciitable.com should be u with umlaut. Any idea ? Best regards, Kovi -- -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- | In A World Without Fences Who Needs Gates? | |... 2 Nov 2006 12:20

Result set from ADMIN_CMD
Hi! I'm trying to use ADMIN_CMD procedure in my SQL procedure like this: DROP PROCEDURE IMPORT_DATA# CREATE PROCEDURE IMPORT_DATA() SPECIFIC IMPORT_DATA MODIFIES SQL DATA NOT DETERMINISTIC LANGUAGE SQL BEGIN ATOMIC DECLARE DATA_REPL_ON_STATUS VARCHAR(10); DECLARE ROWS_READ INTEGER; DECLARE ROWS... 26 Oct 2006 14:43

Error formatting event log
We have had a couple situations where DB/2 died due to someone sending one of the DB/2 processes a kill 9. When this occurs, DB/2 goes down and I noticed in the db2dump directory some files called db2eventlog.000 and db2eventlog.000.crash. I renamed one of them to 00000000.evt and tried to run db2evmon against it b... 26 Oct 2006 10:30

Error accessing Package SYSLH203
All, I am experiencing an issue that has confused me, albiet this is not difficult to do. Any help anyone could provide would be greatly appreciated. After our jdbc calls received the following error: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5... 26 Oct 2006 04:02

db2admin server doesn't start, SQL1042C on AIX
Hi, After installation of a new maintenancelevel on aix (5.3, ML 05) db2 administration server doesn't start anymore. After starting I get the error: SQL1042C An unexpected system error occurred. Did anyone encounter the same problem and knows how to solve this? We ar running db2V8 Fixpak 13. Greetin... 27 Oct 2006 05:53

user exit problem
Hello All... Can someone help me? I can't do a complete database backup per this error: ADM1833E The user exit program returned an error when archiving log file "S0000267.LOG" from "F:_db2_HBQ_log_dir_NODE0000_" for database "HBQ1". The error code was "16". I searched a the file USEREXI... 13 Oct 2006 15:42

question about "select * from new table (update ...)"
I really like the construction: select * from new table (update ....) X but I noticed that it cant be used as: insert into T select * from new table (update ....) X because of: SQL20165N An SQL data change statement within a FROM clause is not allowed in the context in which it was specified. SQLS... 7 Oct 2006 06:07