Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2010
    Posts
    5

    Unanswered: SQL0668N Operation not allowed for reason code "x" on table

    When you loading all database with db2move command, propably most of the tables being loaded are in pending state. To check which ones, execute SQL statement:

    SELECT tabname,status,const_checked FROM syscat.tables WHERE status='C'

    This command will list all tables in pending state


    Reson code:

    * "1" - table is in pending state - to fix this execute

    SET INTEGRITY FOR table_name IMMEDIATE CHECKED

    * "3" - previous load operation on this table failed. You have to terminate or restart previous load command

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by aankdavid View Post

    * "3" - previous load operation on this table failed. You have to terminate or restart previous load command

    What do you do if you don't know the original command used to perform the load? How do you restart or terminate?

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I think you just need to know the table name.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What file name / type will you use? What if load temporary files are missing?

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I am not sure about a restart, but for a terminate:

    db2 load from /dev/null of del terminate into table-name
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What if the table is in load pending on some partitions? (DPF). How do you take it out of load pending state?

  7. #7
    Join Date
    Jan 2010
    Posts
    206
    I think, its the same way then, isn´t it?

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

Posting Permissions

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