View previous topic :: View next topic
|
Author |
Message |
HABBIE
New User
Joined: 08 Jul 2014 Posts: 24 Location: INDIA
|
|
|
|
Hi,
I have connected to the mainframe server by using db2 connect software.
this is the output of my
select current server from sysibm.sysdummy1;
DER89TY
db2 => select * from sysibm.sysdatabase query :
NAME
--------
DSNDB04
DSNDB06
DSNDB07
DSNRLST
DSNATPDB
MTBLRDB
MTHYDDB
DATABAS1
PUBLIC
DSQDBDEF
DSQDBCTL
DSQ1STBB
MTPUNDB
WHOUSE
PUB1
LTESTDB
LENTIDB
HELP
db2 => CONNECT TO PUB1
SQL1013N The database alias name or database name "PUB1" could not be found.
SQLSTATE=42705
Question :
PUB1 is a database under the above list .But throwing the error above.
Why it is happening like this ?
Can someone kindly help me |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
It is NOT 'throwing' an error. DB2 does not 'throw' errors - C, C++, Java etc throw errors. You could have said
Quote: |
But it is giving the error above |
|
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
Nic Clouston wrote: |
It is NOT 'throwing' an error. DB2 does not 'throw' errors - C, C++, Java etc throw errors. You could have said
Quote: |
But it is giving the error above |
|
If it did throw errors, DB2 would throw them faster, more accurately and with more integrity than DBMSes running on other platforms. |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
Just googled for "SQL1013N" and it throwed me back this link... |
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
All hail Google ! |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
on mainframe you connect to a subsystem or instance or SSID.
which are not synonyms for database. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3049 Location: NYC,USA
|
|
Back to top |
|
|
|