Professional Web Applications Themes

What package am I missing? - IBM DB2

Trying to help a friend out with this issue, I am not the DBA on this ..... Whenever we import data (using the DB2 command "import"), we should get a set of informational messages showing us how many rows were inserted/rejected/etc. They look like this: Number of rows read = 31253 Number of rows skipped = 0 Number of rows inserted = 920 Number of rows updated = 30332 Number of rows rejected = 1 Number of rows committed = 31253 Because this package is missing from our system, instead we get this error message: SQL0805N Package "NULLID.SQLUOD01" was not ...

  1. #1

    Default What package am I missing?

    Trying to help a friend out with this issue, I am not the DBA on this
    .....

    Whenever we import data (using the DB2 command "import"), we should
    get a set of informational messages showing us how many rows were
    inserted/rejected/etc. They look like this:

    Number of rows read = 31253
    Number of rows skipped = 0
    Number of rows inserted = 920
    Number of rows updated = 30332
    Number of rows rejected = 1
    Number of rows committed = 31253


    Because this package is missing from our system, instead we get this
    error message:

    SQL0805N Package "NULLID.SQLUOD01" was not found. SQLSTATE=51002

    The imports happen fine - the informational messages are what is
    failing. Can anyone give direction on what DB2 component is missing
    and a way to solve this? They tried to rebind, but to no avail, and
    this has not worked from the begining.

    Thanks in advance for any suggestions.
    M. Krafick Guest

  2. #2

    Default Re: What package am I missing?

    Did you bind at least once from the client platform?

    \bnd>ddcspkgn db2uipkg.bnd

    Bind File Package Name
    ------------------------------ ------------------------------
    db2uipkg.bnd SQLUOE00

    db2uipkg.bnd (CS) Import. Used to check bind options.


    If i remember correctly, the E00 is the platform.

    Maybe it's trying to auto-rebind the utilities but it can't.

    D01 is some windows (95, 98, ... ?) client platform i think. (just a guess
    though)

    Are the server and client using the same platform?
    Probably not since you're missing this package and you said they've rebound
    the utilities.

    PM


    "M. Krafick" <jinx025> a écrit dans le message de
    news:382ff89d.0308260907.19c3b746posting.google.c om...
    > Trying to help a friend out with this issue, I am not the DBA on this
    > ....
    >
    > Whenever we import data (using the DB2 command "import"), we should
    > get a set of informational messages showing us how many rows were
    > inserted/rejected/etc. They look like this:
    >
    > Number of rows read = 31253
    > Number of rows skipped = 0
    > Number of rows inserted = 920
    > Number of rows updated = 30332
    > Number of rows rejected = 1
    > Number of rows committed = 31253
    >
    >
    > Because this package is missing from our system, instead we get this
    > error message:
    >
    > SQL0805N Package "NULLID.SQLUOD01" was not found. SQLSTATE=51002
    >
    > The imports happen fine - the informational messages are what is
    > failing. Can anyone give direction on what DB2 component is missing
    > and a way to solve this? They tried to rebind, but to no avail, and
    > this has not worked from the begining.
    >
    > Thanks in advance for any suggestions.

    PM \(pm3iinc-nospam\) Guest

  3. #3

    Default Re: What package am I missing?

    There is no real client - all this importing, etc are scripts running
    on the server itself. Any other ideas?
    > Are the server and client using the same platform?
    > Probably not since you're missing this package and you said they've rebound
    > the utilities.
    >
    > PM
    M. Krafick Guest

  4. #4

    Default Re: What package am I missing?

    ---------- DB2UBIND.LST
    db2uipkg.bnd

    Can you report if you get errors/warnings when you bind the list
    DB2UBIND.LST.
    Can you report the result of
    DB2 list packages for all | find /i "SQLUOD01"
    or use grep if under unix.
    And why not db2 select * from syscat.packages where pkgname like'SQLUO%'


    PM


    "M. Krafick" <jinx025> a écrit dans le message de
    news:382ff89d.0308271304.8964d4dposting.google.co m...
    > There is no real client - all this importing, etc are scripts running
    > on the server itself. Any other ideas?
    >
    > > Are the server and client using the same platform?
    > > Probably not since you're missing this package and you said they've
    rebound
    > > the utilities.
    > >
    > > PM

    PM \(pm3iinc-nospam\) Guest

  5. #5

    Default Re: What package am I missing?

    Here is what we got after trying your suggestions:

    Error's/Warning's:
    Ran "DB2 bind db2ubind.lst blocking all grant public" (a couple of
    different times now)
    - And got no errors, 2 warnings (both were: "SQL0595W Isolation level
    "NC" has been escalated to "UR". SQLSTATE=01526")

    List Packages:
    $ db2 list packages for all | grep SQLUOD01 <--- the package missing
    in action
    $ db2 list packages for all | grep SQLUID02 <--- an example of one
    that IS there
    SQLUID02 NULLID GAMSD 1 Yes 0 UR
    B

    Query DB's:
    db2 "select * from syscat.packages where pkgname='SQLUOD01'"
    0 record(s) selected.



    "PM \(pm3iinc-nospam\)" <Pm3iinc.NoSpamsympatico.ca> wrote in message news:<%Jo3b.2004$O05.498068news20.bellglobal.com> ...
    > ---------- DB2UBIND.LST
    > db2uipkg.bnd
    >
    > Can you report if you get errors/warnings when you bind the list
    > DB2UBIND.LST.
    > Can you report the result of
    > DB2 list packages for all | find /i "SQLUOD01"
    > or use grep if under unix.
    > And why not db2 select * from syscat.packages where pkgname like'SQLUO%'
    >
    >
    > PM
    >
    M. Krafick Guest

Similar Threads

  1. Links missing/update dialog missing upon file open
    By richarde@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 4
    Last Post: October 5th, 08:07 PM
  2. YouTube videos missing but there...what am I missing?
    By pattyjamas@hotmail.com in forum Macromedia Flash Player
    Replies: 0
    Last Post: August 6th, 03:56 PM
  3. Replies: 0
    Last Post: February 17th, 08:46 PM
  4. DB2 Connect tools complain about a missing package
    By PM \(pm3iinc-nospam\) in forum IBM DB2
    Replies: 0
    Last Post: August 15th, 03:52 PM
  5. PE2 Picture Package missing
    By Beth Haney in forum Adobe Photoshop Elements
    Replies: 2
    Last Post: July 16th, 10:41 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139