Results 1 to 5 of 5

Thread: auto resize

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: auto resize

    Hi,

    what is the command to find out auto resize enabled in particular tablaespace or not?

    Regards,
    K.Manikandan.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    i think list tablespaces show details will help
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Oct 2008
    Posts
    70
    Hi,

    db2 list tablespaces show detail not showing autoresize enabled or not.

    Please give me the command to see the particular tablesapace is in autoresize enabled or not?

    Regards,
    K.Manikandan.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Try the snapshot (for tablespaces, obviously) or SYSCAT.TABLESPACES.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    In addition to tablespace snapshot, you can use a table function starting with v8 fp9:

    db2 "select tbsp_name, tbsp_auto_resize_enabled from table(snap_get_tbsp('db name',-1)) as t"

Posting Permissions

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