[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

DB2 Add Database Problem

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
stretch73
Asked:
stretch73
  • 2
1 Solution
 
sachinwadhwaCommented:
to connect to mainframe, you have to use db2 Connect

do you have DB2 Connect installed?

0
 
sachinwadhwaCommented:
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
 
stretch73Author Commented:
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now