Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Location
    Brooklyn, NY
    Posts
    9

    Question Unanswered: sysmaster:sysshmvals - An officially undocumented table

    Greetings.

    A curiosity led me to the undocumented system table sysshmvals in the sysmaster database. It is very briefly commented in sysmaster.sql and column sh_sysflags is not commented at all. (Oh yeah, telling me it is system flags. Real helpful! )

    Lester Knutsen has addressed a little of this in a recent webcast as well as an old slide show from 2006. But not in the detail I'm looking for.

    Is anyone out there is possession of this luscious information and willing to share it? I'm on an 11.70 server.

    Thanks mucho!

    -- Rasputin Paskudniak (In pursuit of undomesticated, semi-aquatic avians)

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    it is documented in 12.1

    "system operating flags" :-)

    If not documented, this column may change anytime in any release

  3. #3
    Join Date
    Feb 2009
    Location
    Brooklyn, NY
    Posts
    9

    sysmaster:sysshmvals - An officially undocumented table

    Begooden,

    I just downloaded the 12.10 Administrator's Guide and Administrator's reference. Not a bad idea in any case but in bot manuals, a search for the string sysshmvals turn up nada. Similarly for the phrase "system operating flags". In which manual is sysshmvals documented?

    Thanks.

    -- Rasputin Paskudniak (In pursuit of undomesticated, semi-aquatic avians)

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    you will it in $INFORMIXDIR/etc/sysmaster.sql
    in the 12.1 installation. But you are right, a list of the flags value and is missing.

    I can personally live without it :-)

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
  •