 |
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 37 matches |
| Author | Message |
|---|---|
 Topic: zIIP Processing |
|
| vmbigot Replies: 5 Views: 3036 |
 Forum: Database Posted: Tue Oct 20, 2009 12:20 pm Subject: zIIP Processing |
| Kolusu,
I read the same thing and am gratified that I had read it correctly. My suspicion is that the DBM1 address space executes the logic in a native stored procedure as a TCB and the SQL as an ... |
|
| Topic: zIIP Processing |
|
| vmbigot Replies: 5 Views: 3036 |
Forum: Database Posted: Mon Oct 19, 2009 1:29 pm Subject: zIIP Processing |
| Kolusu,
Pardon me for jumping in on this thread. NASCAR9 and I work in the same shop, so I have a vested interest in anything that he does. You stated that the amount of SQL in the native stored ... |
|
| Topic: selective deletion of db2 image copies |
|
| vmbigot Replies: 4 Views: 2341 |
Forum: Database Posted: Tue Jun 03, 2008 1:41 pm Subject: selective deletion of db2 image copies |
| Kolusu,
I've found that I can still use the catalogued image copy datasets as input to a LOAD, even though the dataset is no longer in the SYSCOPY table. Therefore, I am comfortable with setting u ... |
|
| Topic: selective deletion of db2 image copies |
|
| vmbigot Replies: 4 Views: 2341 |
Forum: Database Posted: Mon Jun 02, 2008 5:07 pm Subject: selective deletion of db2 image copies |
| We are using the standard DB2 COPY utility to create image copies, both full and incremental, of all of our databases. We would like to be able to selectively delete image copies out of the SYSIBM.SY ... | |
| Topic: image copy failing on check pending status |
|
| vmbigot Replies: 9 Views: 7385 |
Forum: Database Posted: Thu Apr 12, 2007 3:21 pm Subject: image copy failing on check pending status |
| Dick,
Yes to both. My developers are well aware that if they leave their tables in weird states that they will not be backed up. The first time they need to restore a table from the previous nigh ... |
|
| Topic: image copy failing on check pending status |
|
| vmbigot Replies: 9 Views: 7385 |
Forum: Database Posted: Thu Apr 12, 2007 10:52 am Subject: image copy failing on check pending status |
| Manas,
That is exactly what I was looking for. The ITEMERROR option worked perfectly. In our test database environments, the programmers often leave their test tablespaces in a check pending ... |
|
| Topic: image copy failing on check pending status |
|
| vmbigot Replies: 9 Views: 7385 |
Forum: Database Posted: Mon Apr 02, 2007 4:45 pm Subject: image copy failing on check pending status |
| I do thank everyone for their quick response to my post and your suggestions are very helpful.
However, the suggestions from you and IBM require manual intervention and repair before the backups ru ... |
|
| Topic: image copy failing on check pending status |
|
| vmbigot Replies: 9 Views: 7385 |
Forum: Database Posted: Fri Mar 30, 2007 11:12 am Subject: image copy failing on check pending status |
| We have a production backup job that uses a LISTDEF parm to include all tablespaces in a database that need to have an image copy created. See below for an example:
LISTDEF PCSYLIST INCLUDE TABLESP ... |
|
| Topic: tablespace compression weirdness |
|
| vmbigot Replies: 3 Views: 2198 |
Forum: Database Posted: Wed Mar 07, 2007 12:08 pm Subject: tablespace compression weirdness |
| We have a tablespace that we needed to turn compression on. This tablespace was allocated as follows:
PRIQTY 140000 SECQTY 4000 This allocation created a tablespace size of 1,227 cylinders f ... |
|
| Topic: question regarding BLOB storage utilization |
|
| vmbigot Replies: 1 Views: 1187 |
Forum: Database Posted: Mon Nov 06, 2006 5:21 pm Subject: question regarding BLOB storage utilization |
| We are creating tables with BLOB columns along with the appropriate AUX table for each BLOB column. For example, we have defined a BLOB column as 2K in size. See below for the base and AUX table DDL ... | |
| Topic: tso command listcat output redirection |
|
| vmbigot Replies: 3 Views: 4782 |
Forum: TSO and ISPF Posted: Tue Oct 31, 2006 7:39 pm Subject: tso command listcat output redirection |
| Semigeezer, that is outstanding! I created a little REXX program to perform an IDCAMS LISTCAT command entered against a file in the ISPF 3.4 dataset list. It was suggested that I put the output into ... | |
| Topic: tso command listcat output redirection |
|
| vmbigot Replies: 3 Views: 4782 |
Forum: TSO and ISPF Posted: Mon Oct 30, 2006 7:01 pm Subject: tso command listcat output redirection |
| How do I redirect the output from a LISTCAT ENTRIES (/) ALL command entered in the ISPF 3.4 dataset list panel to a flat file? | |
| Topic: DB2 Control center and DDL |
|
| vmbigot Replies: 6 Views: 3829 |
Forum: Database Posted: Fri Jun 02, 2006 1:34 pm Subject: DB2 Control center and DDL |
| Manas,
We don't have any DB2 UDB for Windows databases here at the office, just DB2 on z/OS. However, I downloaded IBM's free DB2 the other day on my PC at home so I'll test the Control Center gen ... |
|
| Topic: DB2 Control center and DDL |
|
| vmbigot Replies: 6 Views: 3829 |
Forum: Database Posted: Thu May 25, 2006 3:30 pm Subject: DB2 Control center and DDL |
| Kolusu,
Thanks for the assistance. I'll keep digging to find out how to enable this feature in Control Center and update this post when I find out more info. Sooner or later someone else is going ... |
|
| Topic: DB2 Control center and DDL |
|
| vmbigot Replies: 6 Views: 3829 |
Forum: Database Posted: Thu May 25, 2006 1:57 pm Subject: DB2 Control center and DDL |
| kolusu,
Thanks for the link. It does verify that I should have the right-click option to generate DDL, but my Control Center doesn't display that option. I suspect that if I had it, it would run ... |
|
All times are GMT - 5 Hours |