Author |
Message |
Topic: Entire table locked for Tablespace scan ? |
ravikumar_sri2001
Replies: 2
Views: 3702
|
Forum: Database Posted: Sat Sep 06, 2014 2:36 am Subject: Entire table locked for Tablespace scan ? |
Kolusu,
Thank you so much for your help!
Once DB2 completes the above query, it will release "S" lock on the table immediately and it wont hold the lock until COMMIT right ???
Befo ... |
Topic: Entire table locked for Tablespace scan ? |
ravikumar_sri2001
Replies: 2
Views: 3702
|
Forum: Database Posted: Fri Sep 05, 2014 1:40 am Subject: Entire table locked for Tablespace scan ? |
Hi experts,
My application has a segmented table space and it has only one table in it.
LOCKSIZE is ANY. The program that is accessing this table is bound with isolation level CS and it executes a ... |
Topic: DFSORT and SYNCSORT |
ravikumar_sri2001
Replies: 4
Views: 5125
|
Forum: Utilities Posted: Fri Aug 26, 2011 11:55 pm Subject: DFSORT and SYNCSORT |
Experts,
I believe DFSORT is from IBM and SYNCSORT is from SYNCSORT corporation. How do both the products support same syntax ?..
Thanks,
Ravikumar. |
Topic: Infinite loop |
ravikumar_sri2001
Replies: 4
Views: 4286
|
Forum: Job Control Language(JCL) Posted: Mon Aug 22, 2011 9:33 pm Subject: Infinite loop |
I misunderstood Papadi's reply and I apologize for that. Thank you so much for your help! |
Topic: Extract data not in fixed position |
ravikumar_sri2001
Replies: 18
Views: 10033
|
Forum: Utilities Posted: Mon Aug 22, 2011 9:29 pm Subject: Extract data not in fixed position |
Excellent Frank!! |
Topic: Extract data not in fixed position |
ravikumar_sri2001
Replies: 18
Views: 10033
|
Forum: Utilities Posted: Mon Aug 22, 2011 2:47 pm Subject: Extract data not in fixed position |
SQLCODE,
Excellent solution!!...Thank you so much!!!
Ravikumar. |
Topic: Rename a migrated dataset |
ravikumar_sri2001
Replies: 2
Views: 2443
|
Forum: Utilities Posted: Mon Aug 22, 2011 7:30 am Subject: Rename a migrated dataset |
thanks for ur help |
Topic: Infinite loop |
ravikumar_sri2001
Replies: 4
Views: 4286
|
Forum: Job Control Language(JCL) Posted: Sun Aug 21, 2011 11:56 pm Subject: Infinite loop |
Thanks for your reply!
If the JOB class has CPU time limit of 10 Seconds, will the central processor executing that infinite loop run until 10 seconds of CPU time is spent ? |
Topic: Infinite loop |
ravikumar_sri2001
Replies: 4
Views: 4286
|
Forum: Job Control Language(JCL) Posted: Sun Aug 21, 2011 11:16 pm Subject: Infinite loop |
Experts,
If a program goes on infinite loop, will the central processor executing that infinite loop run for ever until we purge the job ?
Thanks in advance for your help!
Ravikumar. |
Topic: Extract data not in fixed position |
ravikumar_sri2001
Replies: 18
Views: 10033
|
Forum: Utilities Posted: Sun Aug 21, 2011 9:52 pm Subject: Extract data not in fixed position |
Experts,
I can give INCLUDE COND=(1,44,SS,EQ,C'R001,R002,R003.....R999') and it will be a lengthy one. Is there any other way ? |
Topic: Rename a migrated dataset |
ravikumar_sri2001
Replies: 2
Views: 2443
|
Forum: Utilities Posted: Sun Aug 21, 2011 12:03 pm Subject: Rename a migrated dataset |
Experts,
In my production, we got a requirement to rename tons of migrated datasets. But SMS is recalling the migrated dataset when we issue ALTER command thru IDCAMS to rename the dataset. Is ther ... |
Topic: Extract data not in fixed position |
ravikumar_sri2001
Replies: 18
Views: 10033
|
Forum: Utilities Posted: Sun Aug 21, 2011 9:24 am Subject: Extract data not in fixed position |
Experts,
The LRECL of the input dataset which has file names is 44 bytes.
Sample input:
XXX.XXX.DSN1
XXX.YYY.SDSFD.DSN2
AXX.BXXX.CXXX.R001
AXX.BXXX.CXXX.R002
AXX.BXXX.CXXX.R003
AXX.BXXX.CX ... |
Topic: Extract data not in fixed position |
ravikumar_sri2001
Replies: 18
Views: 10033
|
Forum: Utilities Posted: Sun Aug 21, 2011 2:21 am Subject: Extract data not in fixed position |
Thanks for your reply! This can be done thru REXX. But can this be done thru SORT ? |
Topic: Extract data not in fixed position |
ravikumar_sri2001
Replies: 18
Views: 10033
|
Forum: Utilities Posted: Sat Aug 20, 2011 10:10 pm Subject: Extract data not in fixed position |
Experts,
I have a list of dataset names in a file. From that list I need to extract dataset names ending with R001,R001,R002 and so on till R999. The length of the dataset names also not fixed.
... |
Topic: Connecting to Windows MQ from mainframe |
ravikumar_sri2001
Replies: 3
Views: 2400
|
Forum: CICS and Middleware Posted: Fri May 16, 2008 6:11 pm Subject: Connecting to Windows MQ from mainframe |
Gupta,
You can either achieve your requirement using distributed queuing or mq clustering. Your mq administrator should be able to help you.
Thanks,
Ravikumar. |
|