Since 4/2/2012 5:37:38 AM, arunrocks has written 9 articles and participated in 0 conversations. arunrocks signature: arunrocks
arunrocks's articles:
Items(9) /1
Clustering using VMWare images - how??033 (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 db21476 (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 - FP14399 (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 line4250 (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 website2270 (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 error2393 (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 variable1240 (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 tablespace2258 (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 time0238 (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