Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Database name in Z/OS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Database name in Z/OS
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: 1714
Location: UK

PostPosted: Fri Aug 07, 2015 7:53 pm    Post subject:
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: 641
Location: Whitby, ON, Canada

PostPosted: Mon Aug 10, 2015 8:42 pm    Post subject:
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: 1219
Location: Israel

PostPosted: Tue Aug 11, 2015 1:01 am    Post subject:
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: 1219
Location: Israel

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

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

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Tue Aug 11, 2015 5:42 pm    Post subject:
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

Senior Member


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

PostPosted: Wed Aug 12, 2015 1:55 am    Post subject:
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
http://www-01.ibm.com/support/docview.wss?uid=swg21571081

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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm
No new posts Database architecture for Mainframe Db2 HABBIE IMS DB/DC 1 Mon Aug 03, 2015 7:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us