Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: Generate DDL (z/OS)

    DB2 version is 10
    DB2 Admin Tool version is 11.1


    I use ADB2GEN to generate DDL in batch. Sample JCL is on p. 222 here:
    http://publib.boulder.ibm.com/epubs/...?noframes=true

    My IN looks like:

    Code:
    ....
      GENSG    = 'Y', 
      GENDB    = 'Y', 
      GENTS    = 'Y', 
      GENTABLE = 'Y', 
      GENVIEW  = 'Y', 
      GENINDEX = 'Y', 
      GENSYN   = 'Y', 
      GENALIAS = 'Y', 
      GENLABEL = 'Y', 
      GENCOMM  = 'Y', 
      GENRELS  = 'Y', 
      GENTRIG  = 'Y', 
      GENSTP   = 'Y', 
      GENSEQ   = 'Y', 
      ACTVCNTL = '', 
      GRANTDB  = 'Y', 
      GRANTTS  = 'Y', 
      GRANTTAB = 'Y', 
      GRANTVW  = 'Y', 
      GRANTSG  = 'Y', 
      GRANSEQ  = 'Y', 
      GRANSTP  = 'Y', 
    .....

    Any doc where all of the GEN... / GRANT... parms are documented?

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    they probably aren't as that is all generated by the tool. You can tell what they are by reading them.
    Generate Storage Group
    Generate Database
    Generate Tablespace
    .....

    If you use the ISPF panels for the tool they are all spelt out, so that you can put yes or no by each of them and then generate your job from there. While in Catalog mode(option 1) just type GEN in front of the tablespace, table, index, etc...
    Dave

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Yes, I used the Admin tool to get IN parms. But if I don't want to use the tool, then I have no way of knowing GENTS generates DDL for the tablespaces.

  4. #4
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Then you are out of luck. All of the vendor tools generate the JCL and their own parms for doing database tasks. We have all altered them in some way or another, changing a table/tablespace/schema, etc..., but that is not supported by the vendor. The response I have received in the past is that you must use the tool to properly do the task at hand. There are very few if any that would support you changing the instream proprietary info.
    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •