Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    29

    Unanswered: list applications show detail in a table

    Hello,
    I'm trying to write a function to retrieve the application names and application ids from the output of the db2 command "list applications show detail".
    I'm thinking about a table function which returns a table with 2 columns (appName and appId).

    Would you suggest a way to do it?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    look in schema sysibmadm
    there are different views that return this data
    Supported administrative SQL routines and views
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2012
    Location
    turkiye
    Posts
    3

    Thumbs up

    hi,

    function in this link ;
    DB2 Universal Database

    example;

    select * from table(SNAPSHOT_APPL_INFO('',-1)) a


  4. #4
    Join Date
    Jan 2012
    Posts
    29
    Thanks Kazahel,
    that's exactly what I was looking for

Tags for this Thread

Posting Permissions

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