DB2

db2updv8 problem
I am running db2updv8 -d databasename and i get this error exec(): 0509-036 Cannot load program db2updv8 because of the following errors: 0509-022 Cannot load module /usr/opt/db2_08_01/lib/libdb2.a(shr.o). 0509-150 Dependent module /home/db2inst1/sqllib/lib/libdb2trcapi.a(shr.o) could not be l... 4 Oct 2006 03:09

Db2 backup
I have this error when restoring my db: SQL2548N Database codepage indicated in backup image differs from that of the current on-disk database. The restore operation has failed. I read the work around but I can do that becouse I have not the codepage of backup (The error I have does not give me it -- see up). ... 2 Oct 2006 06:22

Just Upgraded - Problems...
Hey Guys I have just upgraded from V8,2 to 9.1 Express C and have hit a couple of problems. Here we go: I have created an app in delphi, which connects with the following connection string: Provider=IBMDADB2.1;Password=****;Persist Security Info=True;User ID=USERNAME;Data Source=SMARTMUN;Location=SERVER;Mo... 2 Oct 2006 03:45

how to set idle time out
Hi, I installed DB2 in linux, the tool I can use is db2gov. I'm wondering, how to set the idle time out, so all java app never time out? It's very simple in Mysql, in console, just set wait_time_out=0 -- Thanks John Toronto ... 28 Sep 2006 02:53

JDEdwards date
Hi, Has anybody ever created a DB2 date function to convert a JDEdwards date to a db2 date? Example: September 28 is 106271 in JDEdwards. ... 19 Oct 2006 20:44

BLOB NOT LOGGED
Hi All, I'm working on DB2 UDB 8.2 with Fixpack 10 on Windows 2000 Server. The problem I'm facing is that I have created a table having BLOB type column with NOT LOGGED option. (see script below) CREATE TABLE ATTACHMENTS ( CASEATTACHMENTID INTEGER NOT NULL, ATTACHMENTDATA BLOB(2G) NOT LOGGED ) L... 27 Sep 2006 07:45

SQL0901N on CONNECT
Hi! I have a database v9.1 ESE on Windows. I'm working on Linux. On Linux I have Express-C V9.1. I have started db2ca tool to catalog the database on Windows. The tool gives you the option to test the connection at the end of the wizard. The connection was succesful. But if I try to connect to it through db2cmd ... 22 Sep 2006 09:07

When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030.
Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030. Background: I created a linked server to DB2 8.1 database which called GRR_DB2Serv... 21 Sep 2006 15:27

DB2 ODBC Connection Expiration
I am working on an audit trail mechanism for an MS-Access application that connects to a DB2 backend. We need the APPLICATION_ID to remain constant until the application is terminated. It appears that DB2 connections expire after some duration and new ones are created when needed by the application. Is there a way... 20 Sep 2006 02:52

Problem relating to running Stored Procedures
I hope I can get some help regarding this issue, which has been going on for a while. I have a desktop user who is having problem running "Stored Procedures". The DB2 Connect application works fine but when he runs the stored procedure, he gets the following error message. "SYSPROC".CSGCSB54 - Run started. Dat... 26 Sep 2006 10:07