Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    50

    Unanswered: SQL3805N error on LOAD

    Hi

    I have an error loading a table in a UDB 8.1 db on Sun Soloaris:

    SQL3109N The utility is beginning to load data from file
    "d:\export\ADU.UTADU_ADRESSE.IXF".
    SQL3500W The utility is beginning the "LOAD" phase at time "08-28-2003
    11:23:55.589546".
    SQL3150N The H record in the PC/IXF file has product "DB2 02.00", date
    "20030827", and time "105250".
    SQL3050W Conversions on the data will be made between the IXF file code page
    "850" and the application code page "819".
    SQL3153N The T record in the PC/IXF file has name
    "d:\export\ADU.UTADU_ADRESSE.IXF", qualifier "", and source " ".
    SQL3519W Begin Load Consistency Point. Input record count = "0".
    SQL3520W Load Consistency Point was successful.
    SQL3110N The utility has completed processing. "7561" rows were read from
    the input file.
    SQL3519W Begin Load Consistency Point. Input record count = "7561".
    SQL3520W Load Consistency Point was successful.
    SQL3515W The utility has finished the "LOAD" phase at time "08-28-2003
    11:23:56.736822".
    SQL3500W The utility is beginning the "BUILD" phase at time "08-28-2003
    11:23:56.770879".
    SQL3213I The indexing mode is "REBUILD".
    SQL3515W The utility has finished the "BUILD" phase at time "08-28-2003
    11:23:57.926580".
    SQL3805N The state of the application or of one or more table spaces for the
    table specified prohibits the loadapi action or quiescemode "10". Reason code
    = "1".

    I issued the followings statements, both of them give the SQL3805N error:
    a)
    'LOAD CLIENT FROM 'exportpath||dest.ind.table'.IXF OF IXF MESSAGES 'message' REPLACE INTO 'dest.ind.table' STATISTICS YES AND INDEXES ALL CPU_PARALLELISM 2'

    b)
    'LOAD CLIENT FROM 'exportpath||dest.ind.table'.IXF OF IXF MESSAGES 'message' REPLACE INTO 'dest.ind.table''


    What can be wrong ?

    Thanks Marc

  2. #2
    Join Date
    May 2003
    Location
    Phoenix, US
    Posts
    39
    Hi,
    Can you pls check the state of the tablespaces by executing

    db2 list tablespaces show detail

    probably one of your tablespaces is not in normal status

    Thanks
    Sateesh
    OCP,IBM UDB,SYBASE DBA
    TCS, BANGALORE, INDIA

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    for an MPP system, please execute on all db2 nodes.

Posting Permissions

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