 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 11 matches |
| Author | Message |
|---|---|
 Topic: How to Copy data from Prod to Test Database |
|
| nagapa Replies: 2 Views: 1615 |
 Forum: Database Posted: Fri Jun 08, 2007 6:28 am Subject: How to Copy data from Prod to Test Database |
| Hi,
I am a application developer and doing a bit of db2 admin work for our system. We are trying to refresh our test region with prod data. Is there are way to copy the complete production datab ... |
|
| Topic: Unique number generation Logic |
|
| nagapa Replies: 5 Views: 2743 |
Forum: Application Programming Posted: Thu Oct 20, 2005 9:12 am Subject: Unique number generation Logic |
| Hi Kolusu,
I need it unique but sequential. can we use CREATE SEQUENCE.... I have never used it before. |
|
| Topic: Unique number generation Logic |
|
| nagapa Replies: 5 Views: 2743 |
Forum: Application Programming Posted: Thu Oct 20, 2005 8:27 am Subject: Unique number generation Logic |
| Hello Kolusu,
at the moment we have a id_table that holds 10 records with unique value. Our stored proc, pics a value (based on ur login ind, if ur ids last numeric digit is 1, take the value from ... |
|
| Topic: Unique number generation Logic |
|
| nagapa Replies: 5 Views: 2743 |
Forum: Application Programming Posted: Thu Oct 20, 2005 8:09 am Subject: Unique number generation Logic |
| Kolusu,
Think I have posted this in the wrong place.... I am working on the logic and looking forward for inputs from experts here... Can I move this to other topics... I tried to edit it but can ... |
|
| Topic: Unique number generation Logic |
|
| nagapa Replies: 5 Views: 2743 |
Forum: Application Programming Posted: Thu Oct 20, 2005 7:44 am Subject: Unique number generation Logic |
| Hi,
I have a requirment to write a cobol stored proc that needs to generate a unique number. There could be multiple instatnce of the same procedure and each one should have a unique number. This n ... |
|
| Topic: Table Lock -913 |
|
| nagapa Replies: 5 Views: 2229 |
Forum: Database Posted: Fri Nov 05, 2004 8:55 am Subject: Table Lock -913 |
| Thanks Manas,
As developers we usually dont create table, but I have admin rights. Can I redefine this existing table for LOCKSIZE - ROW, or I have go for a new table and copy across the data from ... |
|
| Topic: Table Lock -913 |
|
| nagapa Replies: 5 Views: 2229 |
Forum: Database Posted: Thu Nov 04, 2004 11:51 am Subject: Table Lock -913 |
| Hi,
I have a program that selects a record from a table and updates it. This table is a counter table, which holds all counter values. My programs picks a specific record from this table, uses the ... |
|
| Topic: Housekeeping datasets to increase availabe DASD/Tape |
|
| nagapa Replies: 10 Views: 4445 |
Forum: Job Control Language(JCL) Posted: Wed Oct 27, 2004 3:42 am Subject: Housekeeping Migrated datasets |
| Hi,
I am a new problem. I can use this JCL for all the datasets that are in DASD. For the datasets that are migrated to tape, this JCL restors them. When this dataset is restored, the last referen ... |
|
| Topic: Housekeeping datasets to increase availabe DASD/Tape |
|
| nagapa Replies: 10 Views: 4445 |
Forum: Job Control Language(JCL) Posted: Thu Sep 16, 2004 8:46 am Subject: Housekeeping datasets to increase availabe DASD/Tape |
| Thanks Kolusu.....
It works. Cheers Nagappan |
|
| Topic: Housekeeping datasets to increase availabe DASD/Tape |
|
| nagapa Replies: 10 Views: 4445 |
Forum: Job Control Language(JCL) Posted: Thu Sep 16, 2004 8:06 am Subject: Housekeeping datasets to increase availabe DASD/Tape |
| Hi Kolusu,
Thanks for your quick reply. I tried this JCL //STEP0001 EXEC PGM=ADRDSSU //SYSPRINT DD SYSOUT=* //LIST DD ... |
|
| Topic: Housekeeping datasets to increase availabe DASD/Tape |
|
| nagapa Replies: 10 Views: 4445 |
Forum: Job Control Language(JCL) Posted: Thu Sep 16, 2004 7:13 am Subject: Housekeeping datasets to increase availabe DASD/Tape |
| Hi,
I have about 4000 datasets relating to my application in development. I have to check for all datasets one by one and decide if I want to retain or delete them, and its a tedious process. ma ... |
|
All times are GMT - 5 Hours |