Solved

DB2 Add Database Problem

Posted on 2006-07-20
3
349 Views
Last Modified: 2010-05-18
I am working with DB2 for the first time and I'm having trouble adding a database.  I am trying to connect to a mainframe through the Client Configuration Assistant but after entering all of the settings, I get the following message:

**************************************************************
The add database operation failed.

SQL1096N  The command is not valid for this node type.
**************************************************************

I am not finding a lot of documentation on this and the settings I have entered appear to work for other people using the application.  

Thanks in advance,

N
0
Comment
Question by:stretch73
  • 2
3 Comments
 
LVL 7

Expert Comment

by:sachinwadhwa
ID: 17145452
to connect to mainframe, you have to use db2 Connect

do you have DB2 Connect installed?

0
 
LVL 7

Accepted Solution

by:
sachinwadhwa earned 200 total points
ID: 17145484
if you have connect installed, to debug further, go to DB2 command window and capture output for following command and post here:

db2level
db2 list node directory show detail
db2 list db directory show detail
db2set -all
set db2
0
 

Author Comment

by:stretch73
ID: 17145810
Tech support finally got back to me, turns out my password was expired.  I find this odd since it was assigned yesterday.  I'm connected now, thank you for the response.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question