Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: DMS tablespace contaner size error

    Hi,

    I tried to restore DB2 UDB two databases into two different instances on AIX server. the raw devices size on the two instances are the same.
    # lsvg -l datavg
    datavg:
    LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
    db2templv jfs 52 52 1 open/syncd /db2temp
    loglv00 jfslog 1 1 1 open/syncd N/A
    RegSpace0 jfs 12 12 1 closed/syncd N/A
    RegSpace1 jfs 12 12 1 closed/syncd N/A
    RegSpace2 jfs 12 12 1 closed/syncd N/A
    RegSpace3 jfs 12 12 1 closed/syncd N/A
    ShortSpace1 jfs 12 12 1 closed/syncd N/A
    ShortSpace2 jfs 12 12 1 closed/syncd N/A
    ShortSpace3 jfs 12 12 1 closed/syncd N/A
    IndexSpace1 jfs 3 3 1 closed/syncd N/A
    IndexSpace2 jfs 3 3 1 closed/syncd N/A
    IndexSpace3 jfs 3 3 1 closed/syncd N/A
    ShortSpace0 jfs 12 12 1 closed/syncd N/A
    IndexSpace0 jfs 3 3 1 closed/syncd N/A
    db2backup jfs 80 80 1 open/syncd /db2/backup
    LongSpace0 jfs 128 128 1 open/syncd /db2/longspace

    when I issue the command "set tablespace containers for 5 replay rollforward container operations using (DEVICE "/dev/rShortSpace1" 196608)
    I got the error: "SQL1422N The size of the container is invalid. SQLSTATE=54039:
    However, it works fine for the other instance as:
    set tablespace containers for 5 replay rollforward container operations using (DEVICE "/dev/rShortSpace0" 196608)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    Does anyone can tell me reason?

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    db2 suggests
    User Response:Check the administration notification log for details. Then
    correct the SQL statement.
    What does the nfy log show?
    mota

Posting Permissions

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