DB2

DB2WSUE License grief. (Permanent license is said the have expiredafter upgrade to FP8.2.6)
Hi hi everyone. We have upgraded our DB2 LUW 8.2.1 which was directly installed from our DB2 CD's to DB2 LUW 8.2.6 (FP13). (system: HP DL385 (AMD64), single socket, dual core. 8GB memory. SLES 10. NetApp FAS250 storage array). This went quite well, but it rendered our permanent (legal) DB2 license invalid, ... 3 Jan 2007 11:28

java.lang.UnsatisfiedLinkError: SQLConnect
i have an application deployed on WAS6.0 that uses a db2 v8.1 database on a linux platform. when i try to run it i get a java.lang.UnsatisfiedLinkError:SQLConnect error. i have tried some solution i foundd on the net like running the .db2profile to set system variables but havent worked.Full details of the error as... 27 Dec 2006 05:02

DB2 9 ESE Fixpack 1 and First Steps
Is there an issue with fixpack 1 on DB2 9 ESE (on Windows) and First Steps? After I applied fixpack 1 I am not able to start First Steps, but get the error message 'DBI1435E Error Opening DB2 First Steps. Cannot find supported Web browser. Explanation: DB2 First Steps requires a supported Web browser.' But In... 22 Dec 2006 04:51

db2licm question (v9)
Hi, I have a 4-processor unix machine running DB2 v9 After installion i activated the license using db2licm -a db2ese_c.lic The output of db2licm -l is as follow (see below) My question is about the line starting with Annotation: I know _c means i activated a CPU license But what is the meaning of -3 ??? T... 19 Dec 2006 09:25

problem starting db with version 9.1
Has anyone come upon this problem? My DB2/LUW 9.1 database seems to be both "started and not started". Check out the following: C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample SQL1032N No start database manager command was issued. SQLSTATE=57019 C:\Program Files\IBM\SQLLIB\BIN>db2start SQL1026N The... 19 Dec 2006 12:42

Audit Triggers
Audit trigger Hello, LUW DB2 V8 FP13 I am trying to create audit triggers in order to find out which user/application is deleting data from a table, as well as the statement the user entered. Here´s what I´ve done: # create table AUD.T_BACKLOG_AUDIT (EVENT_TIME TIMESTAMP, USERNAME VARCHAR(20), STATEME... 17 Dec 2006 03:45

Change column Data Type from Integer to Decimal
I am trying to change my Amount column Data Type from Integer to Decimal (precision 9 digits, scale 3, that is 6 digits to the left of decimal and 3 digits to the right of decimal. Here is the error message I received SQL0443N Routine "SYSPROC.ALTOBJ" I sense this is a security issue, something my DBA must res... 29 Nov 2006 20:41

Linked Server from MSSQL 2005 to iSeries
Hello, I'm trying to create a linked server in Microsoft SQL Server 2005 x64 with SP1 on Windows 2003 Standard x64 with SP1 to an iSeries with V5R2, using Client Access V5R3, service level SI24723. I have this working using an ODBC connection on Windows 2003/SQL 2005 x86 edition, but can't get it working on the x... 28 Nov 2006 14:22

Shared memory issue
Hi , For the past some days i could see the below error on my diag logs, MESSAGE : Unable to create or attach to the segment used for fenced routine communications. Decrease the amount of database shared memory used by your instance, and try again FUNCTION: DB2 UDB, routine_infrastructu... 27 Nov 2006 15:51

restore backup from v7.2 to v9.1
Hi, We got error when try restore offline backup db from v7.2 to v9.1. SQL2514N The RESTORE was not successful. The backup used to restore the database contained a database with a release number that is not compatible with the installed version of the database manager. How it can be done? Thank in advan... 24 Nov 2006 10:54