IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Database name in Z/OS


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
HABBIE

New User


Joined: 08 Jul 2014
Posts: 24
Location: INDIA

PostPosted: Fri Aug 07, 2015 5:52 pm
Reply with quote

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
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2432
Location: Hampshire, UK

PostPosted: Fri Aug 07, 2015 7:53 pm
Reply with quote

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
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 692
Location: Whitby, ON, Canada

PostPosted: Mon Aug 10, 2015 8:42 pm
Reply with quote

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. icon_biggrin.gif
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1348
Location: Israel

PostPosted: Tue Aug 11, 2015 1:01 am
Reply with quote

Just googled for "SQL1013N" and it throwed me back this link...
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1348
Location: Israel

PostPosted: Tue Aug 11, 2015 1:03 am
Reply with quote

All hail Google !
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Aug 11, 2015 5:42 pm
Reply with quote

on mainframe you connect to a subsystem or instance or SSID.
which are not synonyms for database.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2508
Location: NY,USA

PostPosted: Wed Aug 12, 2015 1:55 am
Reply with quote

Check IP/Port and node information is right and and that the DB alias is defined to reference the correct node also see below link
Use [URL] BBCode for Links

Or get in touch with corresponding support team.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Need to fetch data from database base... COBOL Programming 8
No new posts Moving UDB database to Db2 on z/OS DB2 4
No new posts IMS Database backup info IMS DB/DC 14
No new posts Getting list of tables defined under ... DB2 2
No new posts Database access from COBOL DB2 1

Back to Top