Unloading specific records in a foreign key, cascade format.
Hi,We have DB2 version 8, os/390. I know how to use QMF and JCL.I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...
Answer Question
| May 13 2008 6:33 PM GMT
| asked by
Donnaw
DB2 Administration, OS/390, DB2
BMP scheduling of IMS and DB2 database access.
Application developers have nearly completed a conversion from IMS to DB2. They have used BMP to leave their test subsystems available to online tranactions. One day BMP users of BMP failed with U3042. This only occured for BMP users testing with IMS & DB2 databases. I am investigating the...
View Answer
| May 26 2005 1:02 PM GMT
| asked by
elJaymid
DB2, UDB for mainframe, z/OS
IBM DB2 load restart
I am faced with a situation where my SYSREC file for a LOAD could potentially have duplicates. If there are dupes then I have a step that follows that analyses the SYSDISC file,so my DISCARDS is set to 0.If for whatever reason the utility blows up (ran out of space, whatever) and I choose to...
View Answer
| Feb 17 2005 11:45 AM GMT
| asked by
sumithar
UDB for mainframe, z/OS, OS/390
Scalar functions in GROUP BY
Is there a reason why I cannot use a SCALAR function in a Group BY clause?I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sortSELECT COUNT(*), DAYS(TMSTP_COL)FROM MYTAB AGROUP BY...
View Answer
| Dec 30 2004 2:15 PM GMT
| asked by
sumithar
DB2, UDB for mainframe, z/OS
Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
View Answer
| Oct 9 2004 1:41 AM GMT
| asked by
samachar
Implementation, Operating system platforms, Servers
DB2 Automated Utilities - Vendor selection
We use the IBM utilities suite and our own in-house utilities automation for DB2 v7.Our automated utilities is now draining us with heavy maintenance and since V7, there are still a few holes that could cause us some serious damage if not fixed in the near future. However, with V8, we would...
View Answer
| Jun 3 2004 11:08 AM GMT
| asked by
galvtx
IT architecture, Vendors, CIO
Encryption in the Database
Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?
View Answer
| May 12 2004 2:18 PM GMT
| asked by
dw49999
UDB for mainframe, z/OS, OS/390
DB2 Z/os IRLMWT parm
We are considering lowering the lockwait time from the two minute default to 60 seconds and then possibly even lower. What do you have it set to today? Have you had any experience with having it set well below one minute?
View Answer
| May 12 2004 1:33 PM GMT
| asked by
RichardG12
OS/390/z/OS, UDB for mainframe, z/OS
