The Db is shown in the first mail of your's is a Remote DB not a Local
Db, for a local db as for as I know you don't have to catalog it to
access it , but if you're using a Client then you need to catalog it :)
Are you connecting to the DB from client or on the same machine.
And what is the parameter
MAX_CORDAGENT in DB CFG?
Thanks and Regards,
Vishnu Vardan G.
Project Engineer , Wipro Technologies
Bengaluru,India.
>*:vishnuvardan.[Email address protected]
>*: 9740149105
>P Please don't print this e-mail unless you really need to. Save a
Tree.
"It was love at first sight. Then I took a second look!!!!!"
-----Original Message-----
From: manasa
[mailto:db2udbdba-ezmlmshield-x24868179.[Email address protected]
Sent: Thursday, February 28, 2008 7:54 PM
To: LazyDBA Discussion
Subject: Re: RE: connection problem
Hi Geetha,
It is a local database. I used the following command to catalog.
db2 catalog local node instance < instance name>
db2 catalog db at node
Thanks.
On Thu 28/02/08 6:29 PM , "geetha" sent:
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] [1] To Subscribe :
http://www.LazyDBA.com [2] [2] To unsubscribe:
http://www.lazydba.com/unsubscribe.html [3] [3]
Links:
------
[1]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fjobs.lazydba.com
[4]
[2]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.LazyDBA.com
[5]
[3]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.lazydba.com%2Fu
[6]
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 [7] To Subscribe :
http://www.LazyDBA.com [8] To unsubscribe:
http://www.lazydba.com/unsubscribe.html [9] 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 [10]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a dba job: http://jobs.lazydba.com [11] To Subscribe :
http://www.LazyDBA.com [12] To unsubscribe:
http://www.lazydba.com/unsubscribe.html [13]
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
[4]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2F192.168.14.11%2Fpar
se.php%3Fredirect%3Dhttp%253A%252F%252Fjobs.lazydba.com
[5]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2F192.168.14.11%2Fpar
se.php%3Fredirect%3Dhttp%253A%252F%252Fwww.LazyDBA.com
[6]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2F192.168.14.11%2Fpar
se.php%3Fredirect%3Dhttp%253A%252F%252Fwww.lazydba.com%252Fu
[7]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fjobs.lazydba.com
[8]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.LazyDBA.com
[9]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.lazydba.com%2Fu
nsubscribe.html
[10] http://192.168.14.11/parse.php?redirect=http://www.wipro.com
[11]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fjobs.lazydba.com
[12]
http://192.168.14.11/parse.php?redirect=http%3A%2F%2Fwww.LazyDBA.com
[13]
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
DB2 & UDB email list listserv db2-l LazyDBA home page