1
  • 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...

    Galvtx0 pointsBadges:
  • C/C++ for MVS: Reading the master catalog

    I'm trying to get the same output as "ls '*'" from z/OS FTPD. I think this can be done by reading the master catalog. Until now I found no way to open it from C. I found out that the master catalog path is in SYS1.NUCLEUS(SYSCATLG). It says: S6SYS1113CCATALOG.Z16S.MASTER So, my master catalog is...

    Cristit10 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • os390 to apple xserve file loses one byte

    when transfering files from the os390 to an apple xserve the file comes up short one byte, same file from os390 to windows or linux works great. how do I fix this?

    Granpatex5 pointsBadges:
  • 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 sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM MYTAB A GROUP BY...

    Sumithar0 pointsBadges:
  • db2 os/390 v8 utility unload template parms

    Hi, We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally can code...

    SUZB5 pointsBadges:
  • GET OPID SEGMENT CICS FROM A COBOL/DB2/CICS PROGRAM (RACF)

    Please I need Get the OPID segment CICS  of RACF from a COBOL/CICS  Program.   Thanks JORGE

    RACF5 pointsBadges:
  • How to restrict QMF to execute predefined queries only?

    Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael

    Meichhar5 pointsBadges:
  • 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...

    Donnaw5 pointsBadges:
  • 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 issue,...

    ElJaymid0 pointsBadges:
  • 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...

    Sumithar0 pointsBadges:
  • 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?

    RichardG120 pointsBadges:
  • Encryption in the Database

    Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?

    Dw499990 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following