Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

From user managed to DB2 managed

Status
Not open for further replies.
staland

staland

Technical User
Apr 22, 2003
9
DK
Hello,
We're running DB2 v.7 on OS/390, have ca. 120 databases with a total of 1600GB data. We're using user-managed datasets (allocating datasets by IDCAMS) but considering to convert to DB2-managed datasets (using storage groups). (We will not convert to SMS-managed.)
Here's the question:
How do we decide how many storage groups to have and what to put in which group? Which criteria should we use when dividing our data?

Do you have any hints, or do you know where we can find good information / inspiration ??

Regards,
Helle
 
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
383
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
296
tekpr00
tekpr00
C
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
262
chuckw0325
C
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
243
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
300
walter.weinmann
walter.weinmann

Part and Inventory Search

Sponsor

Back
Top