Re: z8 ???

2006-04-04 Thread Isaac Yassin
DITTO Isaac Yassin -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Staller, Allan Sent: Tuesday, April 04, 2006 7:18 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: z8 ??? My unconfirmed source says in the next month or so... snip Any crystal

Re: IBM bundling ...

2006-01-13 Thread Isaac Yassin
Hi, Internally - for SQL - DB2 uses it's own sort routine and does not turn to external product. For utilities (reorg, load) it turns to external sort product Isaac Yassin -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of R.S. Sent: Friday

Re: db2 - delete in batches

2006-01-08 Thread Isaac Yassin
Hi, 1. REORG DISCARD 2. If it's partitioned TS look at LOAD of DUMMY file into the partition to be deleted. 3. Don't delete in 1 SQL. Write a program that will commit every X rows. (X ~~ 500) . However, you'll log in this case. Isaac Yassin -Original Message- From: IBM Mainframe

Re: How to quickly shut down system

2005-12-09 Thread Isaac Yassin
F IRLM,abend,nodump If you are really stuck, this works. However - your DBAs won't be happy. Isaac Yassin -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Hal Merritt Sent: Thursday, December 08, 2005 11:01 PM To: IBM-MAIN@BAMA.UA.EDU

Re: RSVNONR -DB2

2005-07-23 Thread Isaac Yassin
The recommendation is now PC=YES which will be the only option from V8. Isaac Yassin -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Ed Finnell Sent: Thursday, July 21, 2005 6:39 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: RSVNONR -DB2