 |
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 9 matches |
| Author | Message |
|---|---|
 Topic: image copy failing on check pending status |
|
| vini_srcna Replies: 9 Views: 11011 |
 Forum: Database Posted: Tue Apr 03, 2007 12:09 am Subject: image copy failing on check pending status |
| Firstly, Why do you decide to compromise with the restricted states..?
All you have got to do is, to know why the tablespaces are in pending status. What jobs are running before your image copy jobs ... |
|
| Topic: image copy failing on check pending status |
|
| vini_srcna Replies: 9 Views: 11011 |
Forum: Database Posted: Sat Mar 31, 2007 5:17 am Subject: image copy failing on check pending status |
| CHECK PENDING is a restricted state. If the tablespace is in CHKPND status it will not allow any DML issued against it.
I'm not sure, if the STOP DATABASE command can bring the tablspace back into ... |
|
| Topic: can jobs in output queue of spool(IOS) be retrieved to a PS |
|
| vini_srcna Replies: 5 Views: 2369 |
Forum: TSO and ISPF Posted: Fri Mar 30, 2007 11:01 am Subject: can jobs in output queue of spool(IOS) be retrieved to a PS |
| I think you can print the job ouput directly to dataset by giving the data set name @ the SYSOUT ddname. You can also use the command XDC command to print the job output to a PS file. There could be o ... | |
| Topic: Daily job to delete data older than 15 day w/o EX access |
|
| vini_srcna Replies: 6 Views: 6880 |
Forum: Database Posted: Fri Mar 30, 2007 10:52 am Subject: Daily job to delete data older than 15 day w/o EX access |
|
Suppose, you altered your programs to refer to a VIEW instead of the TABLE ? This VIEW would have the records that you are NOT planning to delete. Did you mean to say, the view should be define ... |
|
| Topic: Daily job to delete data older than 15 day w/o EX access |
|
| vini_srcna Replies: 6 Views: 6880 |
Forum: Database Posted: Fri Mar 30, 2007 4:07 am Subject: Daily job to delete data older than 15 day w/o EX access |
| I wish there could have been a window to run your program.
But still deleting 6 lac records using the DELETE statement is a kind of overhead. Why cant you delete all the records at one shot..? May ... |
|
| Topic: Platinum Rapid Recovery issue |
|
| vini_srcna Replies: 3 Views: 2149 |
Forum: Database Posted: Tue Mar 27, 2007 1:11 am Subject: Platinum Rapid Recovery issue |
| Check the count in the table. Is that a unique index..? | |
| Topic: DB2 COMMIT |
|
| vini_srcna Replies: 11 Views: 7873 |
Forum: Database Posted: Sun Mar 25, 2007 11:41 pm Subject: DB2 COMMIT |
| What do you mean by Auto commit in the program..?
Did you mean to say after the step1 executes, it gets commited by itself. The bottom line is: When the plan gets deallaocated (after step1) DB2 c ... |
|
| Topic: isolation levels |
|
| vini_srcna Replies: 13 Views: 8740 |
Forum: Database Posted: Fri Mar 23, 2007 6:04 am Subject: isolation levels |
| and if no of locks exceeds the limit specified in the Tablespace definition, then an escalation happens and this is called as LOCK escalation.
say you have defined a tablespace with LOCKSIZE ROW &a ... |
|
| Topic: Identity Columns |
|
| vini_srcna Replies: 2 Views: 1918 |
Forum: Database Posted: Thu Mar 22, 2007 8:53 am Subject: Identity Columns |
| In short, Yes you can LOAD the unloaded value to the column which is defined as indentity. This is very usefull in keeping the databases in sync. | |
All times are GMT - 5 Hours |