Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Unanswered: Need help with DB2 Load

    We are attemtping a load using a dump file. The load is being run from an app server box (No 15) into a database (box 13).

    We are attempting to capture the specific rows that are not being loaded due to errors and are using a dump file.

    Even though the permissions are ok we are getting error messages on accessing the dump file. We understand that the dump file should be on the database server and have tried placing it on either with the same error.

    Is a mount point required in this situation?
    Can you see what we are doing wrong?

    Card and error message is below.

    Thanks in advance.
    Gerry

    snowcrash7@sbcglobal.net

    The following is the script along with the error message. At the very bottom is the path from which it is being run:

    LOAD CLIENT FROM "/siebel/Sieb_ftt/IN/SCETCOV2" OF ASC MODIFIED BY ANYORDER IDEN
    TITYMISSING DUMPFILE = /home/siebel/logs/dumpit.log NULLINDCHAR=Y METHOD L (208
    241, 314 319, 308 313, 320 329, 173 202, 1 4, 5 6, 8 10, 11 13, 7 7, 91 109, 110
    128, 74 78, 79 81, 14 43, 45 73, 82 84, 85 87, 88 90, 129 142, 143 172, 1 13, 2
    08 237, 240 241, 238 239, 206 207, 203 205, 275 275, 242 260, 261 267, 268 274,
    276 307) NULL INDICATORS (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0) MESSAGES "/siebel/Sieb_ftt/log/loadmsg
    s.err" REPLACE INTO SIEBEL.EIM_FN_DEFADM (VAL_VALUE, ROW_ID, IF_ROW_BATCH_NUM, I
    F_ROW_STAT, DEF_ATTRIB_01, DEF_ATTRIB_03, DEF_ATTRIB_04, DEF_ATTRIB_06, DEF_ATTR
    IB_07, DEF_ATTRIB_08, DEF_ATTRIB_12, DEF_ATTRIB_26, DEF_ATTRIB_34, DEF_ATTRIB_35
    , DEF_ATTRIB_36, DEF_ATTRIB_37, DEF_ATTRIB_38, DEF_ATTRIB_39, DEF_ATTRIB_40, DEF
    _ATTRIB_41, DEF_ATTRIB_42, DEF_DEF_ADMIN_NUM, X_VAL_ATTRIB_03, X_VAL_ATTRIB_04,
    X_VAL_ATTRIB_05, X_VAL_ATTRIB_06, X_VAL_ATTRIB_07, X_VAL_ATTRIB_08, X_VAL_ATTRIB
    _12, X_VAL_ATTRIB_14, X_VAL_ATTRIB_15, X_VAL_ATTRIB_16)FOR EXCEPTION SIEBEL.EIM_
    ERR_TAB NONRECOVERABLE INDEXING MODE AUTOSELECT
    SQL3508N Error in accessing a file or path of type "DUMPFILE" during load or
    load query. Reason code: "1". Path: "/home/siebel/logs/dumpit.log".

  2. #2
    Join Date
    Mar 2004
    Posts
    55

    Clarification

    I should clarify that with the error message we are receiving, I am asking if a mount point between aix boxes is needed for the dumpfile.

    The load does run..we are just rying to identify some bad data in a few rows not being loaded.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you give the instance owner read/write permissions to "/home/siebel/logs"?

  4. #4
    Join Date
    Mar 2004
    Posts
    55

    Thanks!!

    That was it.
    See the load was being run by a developer using another id not the instance owner. We were trying to make sure that THAT ID had write permissions on the dumpfile.

    You nailed it....has to be the instance owner's permission on the dump file.

    Many thanks

    Gerry

Posting Permissions

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