Hi,
have been debugging a problem when fetching blobs and after issuing a
dynamic sql select
select MYBLOB,BLOBUNCOMPRESSLEN from BLOBTABLE where ID=1
and then issueing a fetch I get the following error message and no data is
returned, even though the data was written from the same machine and exists
on the server:
SQL0805N Paket "NULLID.SQL096" nicht gefunden.
On the server the SQL works fine. At other sites where our software is
installed the problem dos not exist, so it must have something to do with
the installation of the client software at this customers' site. The server
has DB2 7.1 FP3 installed, the clients have DB2 7.1 installed. One
speciality at this customers' site is that they use COLUMBUS to install
software on the clients automatically when logging on to the computer. The
DB2 client was installed using this mechanism and the client config list of
alias names were also generated on a test machine and then distributed over
the network. All our other clients had the DB2 client installed directly
from CD and the CCA alias names created locally, which probably avoided the
above issue.
The documentation of this error mentions a few resolutions, which to be
honest I do not completely understand. As we do not use stored procedures or
packages and do not use static SQL we have never had to bind anything to
anything else before, so I do not understand the error. The only resolution
that I could test that makes a little sense to me would be
cd bnd
DB2 connect to ALIAS user db2admin using password
DB2 bind @db2ubind.lst blocking all grant public
DB2 bind @db2cli.lst blocking all grant public
Could some kind soul out there perhaps explain what is causing this problem
and what the above resolution does. I would like to know what the commands
do before I try this out.
Regards
Rudolf Bargholz
------------------------------------------
SQL0805N Paket "<paketname>" nicht gefunden.
Erläuterung: Mögliche Ursachen für den (SQLCODE) dieser Nachricht:
a.. Das angegebene Paket oder Programm ist in der Datenbank nicht
definiert.
b.. Das Programm wurde nicht gebunden oder wurde gelöscht.
c.. Die Anwendung, die ausgeführt wird, ist nicht an die Datenbank
gebunden.
d.. Für die Ausführung eines DB2-Dienstprogramms oder einer CLI-Anwendung
kann es erforderlich sein, die DB2-Dienstprogramme erneut an die Datenbank
zu binden.
Die Anweisung kann nicht verarbeitet werden.
Benutzeraktion: Korrigieren Sie den Namen des Pakets, oder binden Sie das
Programm. Wenn die ausgeführte Anweisung nicht an die Datenbank gebunden
ist, bitten Sie den Datenbankadministrator, die erforderlichen
Bindeoperationen durchzuführen.
Falls die DB2-Dienstprogramme erneut an die Datenbank gebunden werden
müssen, kann der Datenbankadministrator dies mit einem der folgenden
CLP-Befehle vom Unterverzeichnis bnd aus vornehmen, während er mit der
Datenbank verbunden ist:
a.. "DB2 bind @db2ubind.lst blocking all grant public" für die
DB2-Dienstprogramme
b.. "DB2 bind @db2cli.lst blocking all grant public" für CLI.
Benutzer von Systemen mit zusammengeschlossenen Datenbanken: Stellen Sie
sicher, daß die für den Server mit zusammengeschlossenen Datenbanken
erforderlichen Pakete in den entsprechenden Datenquellen gebunden werden.
Weitere Informationen zum Binden von Paketen mit Datenquellen finden Sie im
Handbuch Installation and Configuration Supplement.
sqlcode: -805
sqlstate: 51002 1 3790
Sorry, forgot to mention that the server is running Windows 2000 and the
clients Windows NT SP6a
Regards
Rudolf Bargholz
"Rudolf Bargholz" <ba******@spamcop.net> schrieb im Newsbeitrag
news:br**********@newshispeed.ch... Hi,
have been debugging a problem when fetching blobs and after issuing a dynamic sql select
select MYBLOB,BLOBUNCOMPRESSLEN from BLOBTABLE where ID=1
and then issueing a fetch I get the following error message and no data is returned, even though the data was written from the same machine and
exists on the server:
SQL0805N Paket "NULLID.SQL096" nicht gefunden.
On the server the SQL works fine. At other sites where our software is installed the problem dos not exist, so it must have something to do with the installation of the client software at this customers' site. The
server has DB2 7.1 FP3 installed, the clients have DB2 7.1 installed. One speciality at this customers' site is that they use COLUMBUS to install software on the clients automatically when logging on to the computer. The DB2 client was installed using this mechanism and the client config list
of alias names were also generated on a test machine and then distributed
over the network. All our other clients had the DB2 client installed directly from CD and the CCA alias names created locally, which probably avoided
the above issue.
The documentation of this error mentions a few resolutions, which to be honest I do not completely understand. As we do not use stored procedures
or packages and do not use static SQL we have never had to bind anything to anything else before, so I do not understand the error. The only
resolution that I could test that makes a little sense to me would be
cd bnd DB2 connect to ALIAS user db2admin using password DB2 bind @db2ubind.lst blocking all grant public DB2 bind @db2cli.lst blocking all grant public
Could some kind soul out there perhaps explain what is causing this
problem and what the above resolution does. I would like to know what the commands do before I try this out.
Regards
Rudolf Bargholz
------------------------------------------
SQL0805N Paket "<paketname>" nicht gefunden.
Erläuterung: Mögliche Ursachen für den (SQLCODE) dieser Nachricht:
a.. Das angegebene Paket oder Programm ist in der Datenbank nicht definiert. b.. Das Programm wurde nicht gebunden oder wurde gelöscht. c.. Die Anwendung, die ausgeführt wird, ist nicht an die Datenbank gebunden. d.. Für die Ausführung eines DB2-Dienstprogramms oder einer
CLI-Anwendung kann es erforderlich sein, die DB2-Dienstprogramme erneut an die Datenbank zu binden. Die Anweisung kann nicht verarbeitet werden.
Benutzeraktion: Korrigieren Sie den Namen des Pakets, oder binden Sie das Programm. Wenn die ausgeführte Anweisung nicht an die Datenbank gebunden ist, bitten Sie den Datenbankadministrator, die erforderlichen Bindeoperationen durchzuführen.
Falls die DB2-Dienstprogramme erneut an die Datenbank gebunden werden müssen, kann der Datenbankadministrator dies mit einem der folgenden CLP-Befehle vom Unterverzeichnis bnd aus vornehmen, während er mit der Datenbank verbunden ist:
a.. "DB2 bind @db2ubind.lst blocking all grant public" für die DB2-Dienstprogramme b.. "DB2 bind @db2cli.lst blocking all grant public" für CLI. Benutzer von Systemen mit zusammengeschlossenen Datenbanken: Stellen Sie sicher, daß die für den Server mit zusammengeschlossenen Datenbanken erforderlichen Pakete in den entsprechenden Datenquellen gebunden werden. Weitere Informationen zum Binden von Paketen mit Datenquellen finden Sie
im Handbuch Installation and Configuration Supplement.
sqlcode: -805
sqlstate: 51002
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mark Barinstein |
last post by:
Hello.
w2k, v8.1.2.
I am trying to migrate my replication environment from v6.1. Database TEST
was migrated to v8 successful.
Do I have to run asnmig8 utility to migrate my replication...
|
by: Rudolf Bargholz |
last post by:
Hi,
have been debugging a problem when fetching blobs and after issuing a
dynamic sql select
select MYBLOB,BLOBUNCOMPRESSLEN from BLOBTABLE where ID=1
and then issueing a fetch I get the...
|
by: erkki |
last post by:
Hi,
I have problem with db2 8.1.2. I guess that the origin of the problem
could be my select clause because I use IN operand with huge amount of
items like 'SELECT * FROM TABLE WHERE FIELD IN...
|
by: Oliver Stratmann |
last post by:
Hello All,
we tried to set up a DB2-client for one customer.
The situation was as follows:
There are already DB2-Clients which are configured for the relevant
DB2-databanse.
We exported the...
|
by: Matthew Dauphinee |
last post by:
Is anyone else having trouble using db2advis in V8 Fixpak 7?
I am getting this:
=====================================================================
Using user id as default schema name. Use...
| |
by: Mark |
last post by:
I am running DB2 V8.1 ESE client running on Windows XP Professional
configured to connect directly to DB2 V6.1.2 on OS/390. I can connect
to the OS/390 DB2 database (DB2 subsystem). But when I try...
|
by: Brian Tkatch |
last post by:
Server: DB2/SUN 8.1.6
Client: DB2 Connect Personal Edition (No 11)
<URL:ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winIA32v8/fixpak/FP11_WR21365/FP11_WR21365_CONPE.exe>
...
|
by: TechWitch |
last post by:
Are there any particular DB or DBM parameters that would cause more
occurrences of this SQL error:
SQL0805N Package "NULLID.SYSLH106
0X5359534C564C3031" was not found. SQLSTATE=51002
I...
|
by: tmillett |
last post by:
Need to drop a set of packages from a Db2 v8 fp8 database on AIX. When attempting the drop package command, I'm getting a -805 sqlcode. I've tried the drop command with the version specified and...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |