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.

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 (AT) yahoo (DOT) com> a écrit dans le message de
news:382ff89d.0308260907.19c3b746 (AT) posting (DOT) google.com...

There is no real client - all this importing, etc are scripts running
on the server itself. Any other ideas?

---------- 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 (AT) yahoo (DOT) com> a écrit dans le message de
news:382ff89d.0308271304.8964d4d (AT) posting (DOT) google.com...

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.NoSpam (AT) sympatico (DOT) ca> wrote