Professional Web Applications Themes

How to tell if a MQT is maintained by USER or SYSTEM - IBM DB2

Please don't tell me using DB2LOOK. I only found the following difference when I checked the SYSCAT.TABLES. tabname TYPE STATUS PROPERTY -------- ---- ------ -------------------------------- USRMQT S N Y SYSMQT S N 2 record(s) selected. PROPERTY VARCHAR(32) Properties for the table. A single blank indicates that the table has no properties. But from the explanation for the PROPERTY, I am not sure if I can depend on this. Thanks, FRX...

  1. #1

    Default How to tell if a MQT is maintained by USER or SYSTEM


    Please don't tell me using DB2LOOK.
    I only found the following difference when I checked the SYSCAT.TABLES.
    tabname TYPE STATUS PROPERTY
    -------- ---- ------ --------------------------------
    USRMQT S N Y
    SYSMQT S N
    2 record(s) selected.
    PROPERTY VARCHAR(32) Properties for the table. A single blank indicates
    that the table has no properties.
    But from the explanation for the PROPERTY, I am not sure if I can depend
    on this.

    Thanks,
    FRX


    Fan Guest

  2. #2

    Default Re: How to tell if a MQT is maintained by USER or SYSTEM

    I am curious, what does the CONST_CHECKED column in SYSCAT.TABLES tell you? Is it different or does it say anything?

    CONST_CHECKED CHAR(32) Byte 1 represents foreign key constraints.

    Byte 5 represents materialized query table.

    Encodes constraint information on checking. Values:

    Y = Checked by system

    U = Checked by user

    F = In byte 5, the materialized query table cannot be refreshed incrementally.

    --

    Bob
    Consulting I/T Specialist
    IBM Toronto Lab
    IBM Software Services for Data Management
    [My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]

    "Fan Ruo Xin" <net> wrote in message news:net...

    Please don't tell me using DB2LOOK.
    I only found the following difference when I checked the SYSCAT.TABLES.
    tabname TYPE STATUS PROPERTY
    -------- ---- ------ --------------------------------
    USRMQT S N Y
    SYSMQT S N
    2 record(s) selected.
    PROPERTY VARCHAR(32) Properties for the table. A single blank indicates
    that the table has no properties.
    But from the explanation for the PROPERTY, I am not sure if I can depend
    on this.

    Thanks,
    FRX


    Bob Guest

  3. #3

    Default Re: How to tell if a MQT is maintained by USER or SYSTEM

    Thanks, Bob,
    I will check tomorrow.


    "Bob [IBM]" wrote:
     

    Fan Guest

  4. #4

    Default Re: How to tell if a MQT is maintained by USER or SYSTEM

    Thanks for your answer.
    I did some tests today. I can't depend on the CONST_CHECKED (Byte 5).
    The value of this byte for a MQT which REFRESH IMMEIDATE can also be set
    as 'U' (U = Checked by user).
    Regards,
    FRX


    "Bob [IBM]" wrote:
     

    Fan Guest

  5. #5

    Default Re: How to tell if a MQT is maintained by USER or SYSTEM

    Oh well - worth a try I guess :)

    --

    Bob
    Consulting I/T Specialist
    IBM Toronto Lab
    IBM Software Services for Data Management
    [My comments are solely my own and are not meant to represent an official IBM position - ask my cat!]
    "Fan Ruo Xin" <net> wrote in message news:net...
    Thanks for your answer.
    I did some tests today. I can't depend on the CONST_CHECKED (Byte 5).
    The value of this byte for a MQT which REFRESH IMMEIDATE can also be set
    as 'U' (U = Checked by user).
    Regards,
    FRX


    "Bob [IBM]" wrote:
     

    Bob Guest

Similar Threads

  1. Get System Info->User Name from Flex
    By hgtraining in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: April 28th, 03:19 PM
  2. Replies: 5
    Last Post: November 8th, 05:25 PM
  3. ASP.NET User created on my system?
    By Jim in forum ASP.NET Web Services
    Replies: 2
    Last Post: November 11th, 01:05 AM
  4. User-maintained MQT
    By CRGB in forum IBM DB2
    Replies: 5
    Last Post: July 31st, 12:00 AM
  5. user system name
    By Ray at in forum ASP
    Replies: 0
    Last Post: July 21st, 12:31 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139