arunrocks's articles:

Items(9) /1

Clustering using VMWare images - how?? 0 33 (12/1/2011 12:02:07 PM) comp.os.linux.networking Hi I would like to understand the basics, setup of a cluster. I have a powerful machine in i7, 6 gb ddr3 Ram. I was thinking why not clone a same ubuntu vmware image as 4-5 ones, start them up together and work... Arun

Non-agent threads in db2 1 476 (3/30/2010 4:36:44 AM) comp.databases.ibm-db2 Was reading about workload manager in http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.wlm.doc/doc/c0051417.html "Setting the agent priority for a DB2 service clas... Arun

DB2 Express C - FP1 4 399 (3/28/2010 3:40:03 AM) comp.databases.ibm-db2 I thought Oracle compatibility was enabled in DB2 Express C 9.7.1. But when I did 'db2set db2_compatibility_vector=ORA' it errored out asking me to check the possible values. Is it that it isn' tenabled in E... Arun

Agent_id from the command line 4 250 (1/11/2010 9:19:29 AM) comp.databases.ibm-db2 Hi The requirement is that I want to monitor a long running SP , and mail to the user about whether any lock escalations/waits are happening - once every 30 mins. DB is 9.5 fix pack 5 linux ... Here are som... Arun

Collating seq of a table - copied from serverfault website 2 270 (12/30/2009 6:25:45 AM) comp.databases.ibm-db2 http://serverfault.com/questions/59899/how-to-change-the-collation-of-a-table-column I know, there is the database configuration parameter "Database collating sequence" for setting the collation in db2. But... Arun

mqt creation error 2 393 (12/1/2009 2:18:07 PM) comp.databases.ibm-db2 create table process_table(row_id,claim_id,seq_num) as ( SELECT w.claim_id,w.seq_num FROM ( SELECT row_number() over(),DISTINCT claim_id,seq_num,DENSE_RANK() OVER (PARTITION BY a.icn_num,a.trans_type_cd,a.pr... Arun

need value of the host variable 1 240 (11/24/2009 6:22:41 AM) comp.databases.ibm-db2 Hi I am running an SP that don't log the loop number or anything to find it's progress (not written by me ;) ), and the dev needs info about the same. I ran this SELECT PREP_TIME_WORST, SUBSTR(STMT_TEX... Arun

Please help! set integrity using system tablespace 2 258 (10/29/2009 9:07:16 AM) comp.databases.ibm-db2 1. Why would set integrity use system temporary tablespace? 2. I created one system temp tablespace with 5 g on all nodes - and my table has table partitioning enabled ALONG WITH hash partitioning while the ... Arun

debug - find the network wait time 0 238 (10/28/2009 10:13:30 AM) comp.databases.ibm-db2 Hi I am using a nickname to access in my application. It is very very slow, I need to know if the process in my db si slow or if the remote db is taking so much time to do the join (pushdown is enabled). Is ... Arun