Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    PUNE, INDIA
    Posts
    25

    Post Unanswered: Unable to set the state of a TableSpace to 'Normal'

    Hello ,

    Please can anyone tell me how to set the TableSpace status to Normal. I was trying a Load earlier and for some reason that process ended abruptly, and now unable to access any table on the TableSpace. Currently the TableSpace state is 'Quiesced Exclusive Load Pending'. Please, anyhelp on this will be greatly appreciated.

    Thank you,

    --RAHool.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Unable to set the state of a TableSpace to 'Normal'

    I assume you will know which table LOAD failed ... (or use LOAD QUERY) to find the table .... Run the LOAD Command with the TERMINATE option ....

    HTH

    Cheers


    Sathyaram

    Originally posted by gemini95117
    Hello ,

    Please can anyone tell me how to set the TableSpace status to Normal. I was trying a Load earlier and for some reason that process ended abruptly, and now unable to access any table on the TableSpace. Currently the TableSpace state is 'Quiesced Exclusive Load Pending'. Please, anyhelp on this will be greatly appreciated.

    Thank you,

    --RAHool.

  3. #3
    Join Date
    Dec 2002
    Location
    PUNE, INDIA
    Posts
    25

    Post Here is what i have done !!

    LOAD CLIENT FROM C:\null.txt OF DEL
    MODIFIED BY pagefreespace=0 totalfreespace=0
    coldel~ decpt. timestampformat=""YYYY-MM-DD HH:MMS.UUUUUU""
    MESSAGES D:\msg21.txt
    TERMINATE INTO "CS70DEV".VINGLOSSTERMDESC COPY NO INDEXING MODE AUTOSELECT ;


    I get the following Error after i execute the above command



    SQL3508N Error in accessing a file or path of type "RESTART/TERMINATE INFO"
    during load or load query. Reason code: "1". Path: "".


    Do you have any idea why is it happenning so....

    Thank you .. RAHool

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Here is what i have done !!

    Maybe you can try enclosing the file names withing quotes ...

    Have a look into db2diag.log on both client and server ...

    Have a nice day ...

    Cheers

    Sathyaram

    Originally posted by gemini95117
    LOAD CLIENT FROM C:\null.txt OF DEL
    MODIFIED BY pagefreespace=0 totalfreespace=0
    coldel~ decpt. timestampformat=""YYYY-MM-DD HH:MMS.UUUUUU""
    MESSAGES D:\msg21.txt
    TERMINATE INTO "CS70DEV".VINGLOSSTERMDESC COPY NO INDEXING MODE AUTOSELECT ;


    I get the following Error after i execute the above command



    SQL3508N Error in accessing a file or path of type "RESTART/TERMINATE INFO"
    during load or load query. Reason code: "1". Path: "".


    Do you have any idea why is it happenning so....

    Thank you .. RAHool

  5. #5
    Join Date
    Dec 2002
    Location
    PUNE, INDIA
    Posts
    25

    Post Re: Here is what i have done !!

    Yes, i have tried that. But still it gives me the same message. Is there no way, you can set the TableSpace status to Normal.

    thankx,

    --RAHool

    Originally posted by sathyaram_s
    Maybe you can try enclosing the file names withing quotes ...

    Have a look into db2diag.log on both client and server ...

    Have a nice day ...

    Cheers

    Sathyaram

  6. #6
    Join Date
    Dec 2002
    Location
    cincinnati
    Posts
    18

    how to overcome load pending in db2udb

    Hi,
    In our company we never load ourself since I am a DBA. It is the application personal work. I got into the same problem. I am writing how I fixed the problem. The user doesnot tell me during which table he got the problem. I role db2 diag.log file daily, so we were not having any data for which table it broke etc.,

    For syntax refer documentation.

    Just run this for all the tables in database.

    db2 "load from /dev/null of del messages msg.log terminate insert into schema.tabname"

    You please see the syntack in the db2 books. What happens this will fix the tablespace for whatever the table it broke.

    Thanks
    Jagadish Dara
    jagadish dara

Posting Permissions

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