Results 1 to 3 of 3

Thread: Sqlstate=57016

  1. #1
    Join Date
    Apr 2003
    Location
    Florida
    Posts
    79

    Question Unanswered: Sqlstate=57016

    I'm loading a large amount of data and ran out of space. I allocated more containers to the tablespace and then tried my load again. It failed with an SQLSTATE=57016.

    I reviewed the tablespace via "list tablespaces show detail" and it says a "rebalancing" is taking place?
    Will this happen every time I add containers?

    Thanks -
    Rick
    ***
    [id@test]$ db2 list tablespaces show detail
    Tablespace ID = 12
    Name = TSZSAM01
    Type = Database managed space
    Contents = Any data
    State = 0x10000000
    Detailed explanation:
    DMS rebalancer is active
    Total pages = 2549995
    Useable pages = 2548800
    Used pages = 1699200
    Free pages = 0
    High water mark (pages) = 1699200
    Page size (bytes) = 4096
    Extent size (pages) = 64
    Prefetch size (pages) = 64
    Number of containers = 15

  2. #2
    Join Date
    Apr 2003
    Location
    Florida
    Posts
    79
    I have a lot to learn..... LOL@ME.
    After the tablespace was "rebalanced" I realized the load needed to be either Terminated or Restarted (SQL0668N) - I Restarted and things are now fine.

    Is there a way to see every utility and their status - like "-DISPLAY UTILITY(*)" on the mainframe?

    Rick

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Load has Load query ...

    See if this works ... Useful if you have a series of load commands in your script ...

    For
    db2 -tvf <loadscript> > load1.out

    while true
    do
    cat load1.out | nawk 'BEGIN {}{ if (1>0) { tname=$NF }} END {
    print tname}
    ' | while read tname
    do
    db2 load query table $tname
    done
    sleep 60
    done

    (Don't ask me , why there is a check 1>0 :-) , i don't remember why)
    Good luck



    Cheers

    Sathyaram

    Originally posted by Rick-dba
    I have a lot to learn..... LOL@ME.
    After the tablespace was "rebalanced" I realized the load needed to be either Terminated or Restarted (SQL0668N) - I Restarted and things are now fine.

    Is there a way to see every utility and their status - like "-DISPLAY UTILITY(*)" on the mainframe?

    Rick
    Last edited by sathyaram_s; 04-30-03 at 15:13.

Posting Permissions

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