This is complicated so I will try to be specific.
Server: W2K DB2 V8.1 fixpack 4
Instances: DB2 databases TOOLSDB, DBDC
DEV databases SURVEY, QUALDEV, DBDCDEV
STAGE databases WSWSTAGE, TEMP
I am having a problem I created the development box and things have
been going well. I started to use Federation and things have gone
south. I enabled federation on the DEV and DB2 instances to do some
tests. I then needed to create a new database on the system. I
created one on the DEV instance and it created fine and loaded all the
data but my users can not connect to it. When they do the get the
following error
"CLI connection failed.
SQL30061N The database alias or database name "DBDCDEV "
was not found at the remote node. SQLSTATE=08004"
I then decided to try to try to build it under a different instance
and when I built it under the DB2 instance they could connect to it.
I had some users who had not connected to the QUALDEV database and
under the same instance they can connect to that database. Whatever
is causing the problem is only effecting new databases under two of
the three instances not databases that had been created in the past.
I have compared dbm cfg for both instances and other than size of
config parameters nothing is different. Can anyone give me a guess on
what to try? I have tried changing the svcename, I turned off
federation I have created a new instance and can't connect to
databases created on the new instance. Where do I start? 1 5068
Steven wrote: This is complicated so I will try to be specific. Server: W2K DB2 V8.1 fixpack 4 Instances: DB2 databases TOOLSDB, DBDC DEV databases SURVEY, QUALDEV, DBDCDEV STAGE databases WSWSTAGE, TEMP I am having a problem I created the development box and things have been going well. I started to use Federation and things have gone south. I enabled federation on the DEV and DB2 instances to do some tests. I then needed to create a new database on the system. I created one on the DEV instance and it created fine and loaded all the data but my users can not connect to it. When they do the get the following error "CLI connection failed. SQL30061N The database alias or database name "DBDCDEV " was not found at the remote node. SQLSTATE=08004" I then decided to try to try to build it under a different instance and when I built it under the DB2 instance they could connect to it. I had some users who had not connected to the QUALDEV database and under the same instance they can connect to that database. Whatever is causing the problem is only effecting new databases under two of the three instances not databases that had been created in the past. I have compared dbm cfg for both instances and other than size of config parameters nothing is different. Can anyone give me a guess on what to try? I have tried changing the svcename, I turned off federation I have created a new instance and can't connect to databases created on the new instance. Where do I start?
Each instance uses a different TCPIP port. It sounds to me like you
have (on client workstations) cataloged the DBDCDEV or QUALDEV databases
using the wrong instance (i.e. port). Make sure your DB2 client
machines are pointing to the correct port on the server for each
database.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: pcchong |
last post by:
I have 3 websites and make use of free counters provided by other web
hosting companies to count the no of hits. Now I want to install a
multiple-user databased driven asp counter (with initial value setting) in
one of my sites to provide the statistics. I try to use the google search to
look for a free script but to no avail. Anyone know of a free asp script
that I could use for this purpose? Thanks.
pcchong
|
by: Marcos |
last post by:
Yesterday afternoon I lost access to my local MSDE 2000 sp3(a?)
instance. Usinig NT or SQL authentication I get an 'access denied'
error when I try to connect. This happened suddenly with no changes
to the server on my part. I've tinkered with the Client Network
Utility settings, from Multiprotocol only, every combination of Multi
protocol, TCP/IP, and named pipes. I've tried connecting with my
network machine name, using (local), and...
|
by: David Moore |
last post by:
Hello
I posted a thread about this a while back, but I can't actually find it
again so I can reply to it with the solution I found, so I'm making a new
thread and hoping it goes to the top of the Google search results for the
error like the previous thread.
This is actually a solution to a problem, not a call for help, so you can
stop reading now unless you're actually interested in the solution :)
|
by: kamilla |
last post by:
I have a mysql 3.5 server installed on a suse linux 8.1, with address 10.0.0.100.
Now I want to access that db from a W2K pc, address 10.0.0.200.
I am able to ping 10.0.0.100, but I cannot connect to the db, and get error 2013.
I have tried with MySQL Administrator 1.0 and also with ODBC.
The db on linux has
grant all on *.* to ''@'10.0.0.%'
and also tried
.... to root@10.0.0.200
and others seen on posted messages.
I can access that db...
|
by: dstewart |
last post by:
Situation:
One common MySQL database server on SuSE 9.1 with all updates.
Uses 'rinetd'. Has entries for the appropriate IP addresses of all
servers.
NOTE: If the appropirate entries are NOT in rinetd, the error message
is:
ERROR 2013: Lost connection to MySQL server during query
Using the exact same query from prompt on several clients (some are
SuSE 9.1, some are older Redhat systems, but none are configured
| |
by: Ann Marinas |
last post by:
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed both the iis and sql server in a single machine. Not too
long ago, the machine had some hardware problems, and management has
decided to purchase new servers, for both asp.net and sql server.
|
by: deltalimagolf |
last post by:
I now get the following error message after copying an asp.net application to
the deployment web server. I don't have SQLExpress or any version of SQL
2005 installed. I found the "LocalSQLServer" connection string in the
machine.config, changed that to look at a SQL 2000 database, but the error
still comes up.
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be...
|
by: John Shadel |
last post by:
I have the following setup:
1. ASP.NET 2.0 web app hosted on a web server (inetpub directory
hosting physical files of the web site on a different drive name, E:
than the SQL Server Instance, which is on C:)
2. SQL Server on the same server, with security settings enabling
ASPNET group and groups containing users allowed to interact with the
website added to SQL Server Instance security settings.
3. Impersonation = true, i.e. ASPNET...
|
by: selvamcbe |
last post by:
sir
I have a problem with installtion of phpbb 2 Forum in my website...
I am having a website named http://www.clickonlinejobs.com Also i plan to include forum with it.So i have added my forum in my sub domain named
http://www.forum.clickonlinejobs.com...
Here is the steps what i done for installation
1.Based on Flash video tutorial which available in http://www.phpbb.com i copied my extracted phpbb files into my sub domain which...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |