Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2009
    Location
    Calgary, AB Canada
    Posts
    38

    Unanswered: writing a stored procedure to collect 'admin cfg' parameters

    I would like to create a stored procedure that will collect the parameter values of the admin cfg output and place them into a table, or to be able to query them directly.

    How would I go about doing that? I never tried to write something like this.

    Thanks,
    Bulump

  2. #2
    Join Date
    Nov 2011
    Posts
    334
    if you used DB2 v9 or later ,there are two views sysibmadm.dbcfg and sysibmadm.dbmcfg that can meet your requirement.

  3. #3
    Join Date
    Oct 2009
    Location
    Calgary, AB Canada
    Posts
    38
    actually, that's not the case. The DAS information is not included within those views...

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The DAS has been depricated, which means it will likely be removed in some future release. This is mainly because Control Center has been depricated.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Nov 2011
    Posts
    87
    we are running on v9.7 fp3a (win 2008 r2). and I am using DAS for the HADR.

    How can we set up the HADR without DAS?

    Thanks.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by db2mtrk View Post
    I am using DAS for the HADR.

    How can we set up the HADR without DAS?
    What do you mean by "using DAS for HADR"? You mean using Control Center to setup HADR?

Posting Permissions

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