IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How many database can a DB2 subsystem contain?
IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies. Quick References
View previous topic :: View next topic  
Author Message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China
PostPosted: Sat Sep 22, 2012 10:57 am
 Reply with quote
From the grammar of 'CREATE DATABASE' , since there is no 'DB2 SUBSYSTEM' option, I suppose only one database can be created within a specified DB2 subsystem. I do not quite sure if I'm right or not.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
PostPosted: Sat Sep 22, 2012 11:20 am
 Reply with quote
Maximum number of databases 65217 in Db2 Zos V10.

Check - publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_limits.htm
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
PostPosted: Sun Sep 23, 2012 5:10 am
 Reply with quote
Hello,

Quote:
I suppose only one database can be created within a specified DB2 subsystem
Why might you suppose this . . . icon_confused.gif (rhetorical question - no reply needed).

Topic locked to prevernt further proliferation. . .


d
Back to top
View user's profile Send private message
View previous topic : : View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts What database does Jobtrac use CA Products 4
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
No new posts Retrieve IMS SubSystem Name IMS DB/DC 2
No new posts Get name of Subsystem routine is exec... All Other Mainframe Topics 2
Search our Forums:


Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us