Solved

DB2 Add Database Problem

Posted on 2006-07-20
3
347 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now