DB2
in [SQL]
|
Commit the applied FixPak?? ENVIRONMENT: ============ (1) AIX 5.2 ML 8 and AIX 5.3 TL 4. (2) DB2 ESE on some servers and DB2 Connect Enterprise Edition on others. QUESTION: ========= I upgrade DB2 on some 15 Production servers using 'installFixPak -ay', from 8.1.4 to 8.1.11. All upgrade steps successful, goal achieved much before time,... 31 Mar 2007 13:07
dascrt errors I am trying to create dasusr1 (db2 admin user) by doing the following: START-------------------------------- [root(a)plin-db2-stg01 instance]# ./dascrt dasusr1 DBI1088E Invalid access permission detected for directory /home/dasusr1/das. Explanation: There may be several reasons for this error. It is... 21 Mar 2007 17:20
unixODBC Hi! I have DB2 Express-C v9.1 installed on my machine. It is Linux UBUNTO 6.10. I've installed unixODBC version 2.2.11. My /etc/odbcinst.ini: [ODBC] Trace=yes Tracefile=/home/gregor/trc.log [DB2] Description=DB2 Driver Driver=/opt/ibm/db2/V9.1/lib32/libdb2.so Driver64= Setup= Setup64= UsageCount= CPTi... 13 Mar 2007 13:12
Autoincrement DB2 JBOSS EJB CMP J have database DB2 and create table T_TEST with fields: ID - integer autoincrement NAME - varchar(50) QTY - Integer I create java bean CMP and install it on Jboss server and when create new record from client I get error: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -798, SQLSTATE: 428C9, SQLERRM... 2 Mar 2007 14:29
DB2 load with error SQL2044N Reason Code "3" I have db2 ESE v9 fix pak 2 installed on red hat linux kernel 2.6. When I use db2 load facility even with 1 row to be inserted, I see this error message: SQL2044N An error occurred while accessing a message queue. Reason code: "3". I read some post online about SQL2044 and learned sometimes it is about the li... 27 Feb 2007 19:09
Too many open files error on db2diag.log Whenever datastage (ETL Tool) tries to establish more than 2 connection to database it fails with the error SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032 Environment: AIX 5.3 DB2 UDB V8.1... 27 Feb 2007 13:13
What is the fastest way... Hi everyone! I have two tables, T1 and T2 defined as follows: create table T1(c1 integer not null, primary key (c1)); create table T2(c1 integer not null, c2 varchar(100) not null, primary key (c1, c2)); populated with example data: insert into t1 values (1), (2), (3); insert into t2 values (1,... 24 Feb 2007 18:50
SQL1477N Table "<table-name>" cannot be accessed Hello, I get the following error when I try to insert data into a table. "SQL1477N Table "<table-name>" cannot be accessed. " The table was created with NOT LOGGED INITIALLY The import is done by a program written in C and using embedded SQL. It starts with ALTER TABLE myTable ACTIVATE NOT LOGGED INITIALLY WI... 20 Feb 2007 10:39
Memory Heap Error Hi All: I use db2 v8.1 fixpack 3 on AIX 5.1. I used to get a memory heap error few months ago. I sorted it out by setting the NUM_POOLAGENTS and MAXAGENTS equal. Also there was an issue with the event monitor reaching max space limits which was sorted out. Now there is no issues with the parameters or the eve... 14 Feb 2007 13:22
LOGARCHMETH1 We are currently using Userexit to archive DB2 logs. I updated the db cfg as follows: db2 update db cfg for capfpk02 using LOGARCHMETH1 DISK:/cfpkloc4/ archivedlogfiles/capfpk02 I assumed that the archived log files are going to the above directory. But actually it is going to the following directory. /cfpk... 13 Feb 2007 18:51 |