Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    2

    Unanswered: DTS does not work with DB2 v8.2

    Since update to V8.2. We can no longer get out DTS packages to work.
    I seem to be getting a schema error in regards to my connect driver.
    I am still using the Microsoft OLEDBConnect which has always worked before.
    Anyone else have the same problem and know of a fix.

    Thank You
    DS

  2. #2
    Join Date
    Jul 2005
    Location
    Irvine, CA
    Posts
    23
    You may need to rebind the db2schema.bnd package.

    From ../sqllib/bnd run:

    db2 bind db2schema.bnd blocking grant public all

    You may not want public to have rebind privs on packages, so just revoke these after the bind.

    Hope this helps.

    Steve
    IBM Certified LUW DB2 DBA

Posting Permissions

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