Solved

DB2 Add Database Problem

Posted on 2006-07-20
3
351 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

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 (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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

751 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