Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Location
    Bordentown, NJ
    Posts
    27

    Unanswered: SQL Server to Main Frame

    I'm trying to send data from a table on SQL server to a DB2 table on the Main Frame and I get this error. Any ideas?

    [IBM][CLI Driver][DB2]SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "UPDATABLE WORKFILE", type of resource: "100", and resource name: "TEMP DATABASE". SQLSTATE=57011

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Show it to your MF DBA (I hope you have one).
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jun 2004
    Posts
    10
    There will be appropriate info in the DB2xMSTR started task on the mainframe. Ask the DB2 Systems administrator or DBA to look into this job, and you should find the resource that you are having trouble getting to. It sounds like you have connected correctly to the mainframe.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How did you establish the connection?

    I usually set up a bcp out, ftp to the mainframe, then DSNTIAUL and LOAD RESUME...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    May 2004
    Location
    Bordentown, NJ
    Posts
    27

    Unhappy New error

    A big thanks to everyone for all your suggestions. We ended up creating the TEMP db on the M/F. Now, we get past that error but there's a new one, as follows:

    "The number of failing rows exceeds the maximum specified."

    I'm assuming this is an SQL server error? How do I check the Max?

Posting Permissions

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