DB2

DB2 taking a long time to start archiving logs
For some reason, DB2 is taking a long time to start archiving the logs. Pls, do you know what could be causing it? I see the following msgs on db2diag.log 2008-09-04-00.36.24.414103+000 I415281A322 LEVEL: Warning PID : 1585198 TID : 1 PROC : db2loggr (SGPPBWG2) 0 INSTANCE: u... 5 Sep 2008 00:19

db2ckpwd not running under root
We have a small problem in one of our database hosts in which the db2ckpwd daemon process runs under the instance owner id instead of "root". Due to this, no other id except the instance owner is able to start the database instance. I see the following error messages in the diag if a 'db2start' is attempted b... 3 Sep 2008 11:18

remove DB2 Connect Server ?
Hi, I have installed DB2 9.5 directly from FP1 on Windows in custom mode with COMP=CONNECT_SUPPORT. I then added my DB2 Server license. I am surprise that db2licm refers to a DB2 Connect Server. Is there a way to remove the product I have never installed ? db2licm -l Product name: "DB2... 2 Sep 2008 13:45

Large number of reads on sysibm.sysuserauth.
I am getting a large number of reads on the sysibm.sysuserauth table over a relatively short period of time that correlates with a batch load. I assume that sysuserauth is read when a user connects to and authenticates with DB2. Does a large number of reads against this table indicate multiple connections to and ... 27 Aug 2008 06:24

db2ckpwd uses a lot of memory
On Aug 4, 5:33 am, danfa...(a)hotmail.com wrote: Hi! I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on a single server. The  db2ckpwd  4*3 =12 processes each uses 959220 k of memory which totals +10GB. Also the  four db2wdog processes each uses +1GB Are these figures normal? ... 5 Aug 2008 01:56

db2ckpwd uses a lot of memory
Hi! I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on a single server. The db2ckpwd 4*3 =12 processes each uses 959220 k of memory which totals +10GB. Also the four db2wdog processes each uses +1GB Are these figures normal? Can they be configured? /dg ... 4 Aug 2008 16:42

Problem While loading from Client Database
Greetings, I'm using Db2 9.5 for LUW. i have file which need to be loaded into the table and its residing the server path c:\load. now i have invoked the load command from claint, but it's giving error like below. "SQL3126N Remote client requires absolute path for files and directories." would anybod... 31 Jul 2008 13:24

TRANSLATE function
Hi, Does anybody know why i get this error: SQL0176N The second, third or fourth argument of the TRANSLATE scalar function is incorrect. SQLSTATE=42815 with this query: SELECT TRANSLATE(p.meno, 'aaaaccdeeeiillnnoooorrsstuuuuyzzAAAACCDEEEIILLNNOOOORRSSTUUUUYZZ', 'áâãäæèïéìëíîåµñòóôöõàø¶¹»úüûùý¼¾ÁÂÃÄÆÈÏÉÌËÍÎÅ¥... 1 Jul 2008 17:29

Reorgchk, Reorg, Runstats not having any effect after completion. Why is this?
Hi all, I am very surprised to see that after doing a Reorgchk followed by reorg of selected tables and concluding with a runstats of the reorged tables, all of the tables continue to be identified and selected as reorg candidates in subsequent/followup reorgchk. Has anyone had this experience? Can you share wit... 29 Jun 2008 17:16

heavy inserts and bufferpool
<dcruncher4(a)aim.com> wrote in message news:fuevgh02ug6(a)drn.newsguy.com... I am new to DB2. version info DB2 9.5 , Linux some more info:- create bufferpool bp1 size 140000 pagesize 8K ; update db cfg for test using CHNGPGS_THRESH 5 ; update db cfg for test using NUM_IOCLEANERS 3 ; update db cfg... 23 Apr 2008 09:19