RE: connection problem

RE: connection problem

 

  

Nullius in verba.
In order to list applications on a remote instance, you first need to attach
explicitly to that instance.
The listing below shows the catalog entry for the database SIEBELDB as a
remote database. Consequently the instance at node NDE9DC27 is remote; (and
indeed, with the obscure and now defunct exception of a loopback database,
there would be no point cataloguing it otherwise).
HTH
Alex Levy
Sustainable Software Ltd.

-----Original Message-----
From: geetha
[mailto:db2udbdba-ezmlmshield-x53017469.[Email address protected]
Sent: 28 February 2008 12:59
To: LazyDBA Discussion
Subject: RE: connection problem

Hi,

Is that database local or remote?? And what are you trying to do,also give
the command you have used to CATALOG the database.


Thanks,
Geetha

-----Original Message-----
From: manasa
[mailto:db2udbdba-ezmlmshield-x44158656.[Email address protected]
Sent: Thursday, February 28, 2008 6:11 PM
To: LazyDBA Discussion
Subject: connection problem



Hi DBA's,

I cataloged localy one database in windows server. Though no one is
connected with that database, but it is giving SQL1226 the maximum no of
client cunnection are already started. SQLSTATE= 57030

When I using list application it is returning no data.

NODE directory entry :

Node name = NDE9DC27

Directory entry type = Local

Protocol = Local

Instance name = LOYADM

DB directory entry:

Database alias = SIEBELdb

Database name = SIEBELDB

Node Name = NDE9DC27

Directory entry type = Remote
Can you please help to fix that problem.

Thanks.
On Thu 28/02/08 4:51 PM , "Kiran R Gumraj " sent:
Hi All,
Can you please help us on this,
We need to insert records from Excel into DB2 tables and we need to use
"Parameter markers" for doing this.It has to be done through open system(
Java/ODBC). Please let me know how can we do this, Thanks for your time and
help again.
Great Day !!!
Kiran G R
Computer Sciences Corporation India Private Limited Registered Office:
Electronics Complex, Software Technology Park, Indore, Madhya Pradesh,
India Registered in India No: 10-11210

------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to
any order or other contract unless pursuant to explicit written agreement
or government initiative expressly permitting the use of e-mail for such
purpose.

------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------------------------------

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com [1] To Subscribe : http://www.LazyDBA.com
[2] To unsubscribe: http://www.lazydba.com/unsubscribe.html [3]


Links:
------
[1]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fjobs.lazydba.com
[2]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.LazyDBA.com
[3]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.lazydba.com%2Fu
nsubscribe.html

Disclaimer: This communication is for the exclusive use of the intended
recipient(s) and shall not attach any liability on the originator or ITC
Infotech India Ltd./its Holding company/ its Subsidiaries/ its Group
Companies. If you are the addressee, the contents of this e-mail are
intended for your use only and it shall not be forwarded to any third
party, without first obtaining written authorization from the originator or
ITC Infotech India Ltd./ its Holding company/its Subsidiaries/ its Group
Companies. It may contain information which is confidential and legally
privileged and the same shall not be used or dealt with by any third
party in any manner whatsoever without the specific consent of ITC
Infotech India Ltd./ its Holding company/ its Subsidiaries/ its Group
Companies.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html


The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.

www.wipro.com



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page