Solved

DB2 Add Database Problem

Posted on 2006-07-20
3
352 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

623 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