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
 

 

Storage group help

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Wed Aug 08, 2012 9:45 pm    Post subject: Storage group help
Reply with quote

My problems with that test database I'm trying to load just don't seem to end. The current problem is it is running out of space on a volume when attempting to extend an index that is being created. I'd like to add a volume to the storage group but the storage group is currently defined with * as the volume ID. So when I attempt to change it, I get:

DSNT408I SQLCODE = -655, ERROR: THE CREATE OR ALTER STOGROUP IS INVALID BECAUSE THE STORAGE GROUP WOULD HAVE BOTH
SPECIFIC AND NON-SPECIFIC VOLUME IDS

So, how do I add another volume when non-specific volume IDs are specified? Or, how do I get DB2 to use a different volume for this index?

I assume I have to add a volume to SMS managed space, but that may still have space issues?
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Aug 08, 2012 10:39 pm    Post subject:
Reply with quote

A couple of things,
(and i have spent about 1/2 hour deciding what I would write):

1. I am sure Data Kinetics is billing the shit out of Marine One Bank
for your 'free' dba work.

2. I am sure you are starting to appreciate why there are db2 application developers,
and db2 dba's.

3. Storage group definitions are basic
(one of the first defintions provided to db2 to describe your environment)
so I have no idea where you have to start again
if an 'extend' storage group function is not available.
lot depends on your db2 version.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 08, 2012 11:32 pm    Post subject:
Reply with quote

Hello,

Is there not a storage management group for such things?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Aug 08, 2012 11:41 pm    Post subject:
Reply with quote

dick scherrer wrote:
Hello,

Is there not a storage management group for such things?

Without insult to Mr. Poulakos, if he's been anointed a DBA for lack of anyone else, what's the probability that there are experienced storage management analysts?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 09, 2012 1:32 am    Post subject:
Reply with quote

Well, i've been lots of places that had no dba (which is why i was invited to play - just not db2) but Someone was always responsible for the dasd, carts, robots, etc . . .
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Thu Aug 09, 2012 1:55 am    Post subject: Reply to: Storage group help
Reply with quote

You are right, I do work for Data Kinetics. But, nobody is getting billed for this effort and I have no idea who Marine One Bank is. The work I'm doing is strictly for a PoC and I'm pretty much on my own to make this work. We don't have a large mainframe staff, so we do whatever we have to do. I would never seek free help for something I was billing for.... if I know something well enough to bill for it, I wouldn't be asking questions.
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Thu Aug 09, 2012 2:53 am    Post subject: Reply to: Storage group help
Reply with quote

If I didn't make this clear before, Data Kinetics is not a contracting shop, we are a software development firm specializing in memory management products. We have never needed a DBA or dedicated storage management staff. We are not that large.

In this case, my guesses proved correct and my database is complete.

For those who are interested, we added another volume to SMS and did a SPUFI command to Alter storage groups:

ALTER STOGROUP SG9GDKL
ADD VOLUMES ('*');
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Aug 09, 2012 7:31 am    Post subject:
Reply with quote

My apologies John if my comments were a little too quick.
Found your name in Linkedln associated with Marine One
and made the leap.

anyway, I salute your perseverance and now understand
(due to your background)
your unhesitating courage to jump into this project.

I do appreciate the return post,
and if I (or we) can be of help in the future
i think it may possibly benefit us more than you.

by the way, in your pursuit of a solution,
did you run across this article by Robert Catteral
which provides background for the actual
DB2 SQL statement solution which you have provided.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 09, 2012 8:00 am    Post subject: Reply to: Storage group help
Reply with quote

Congrats on getting this working icon_smile.gif

We definitely appreciate the followup and you posting the solution.

We'll be here if there are any other "adventures".

d
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 49
Location: United States

PostPosted: Thu Aug 09, 2012 11:25 pm    Post subject: Reply to: Storage group help
Reply with quote

Just an FYI for all the help I have received, creation of this database is needed to drive this SQL: http://ibmmainframes.com/viewtopic.php?t=58630. Thanks to the explanation I was given and based on some of my own research, I have been able to break down what DB2 is doing under the covers. I have been able to design a recursive internal loop that improves performance by 40% or more. Now all I have to do is make it work and prove it! The ultimate goal will be for a client to provide some environmental and procedural information about the SQL, which we will intercept and drive through our code. But, that is a long way off.

I may be an ignoramus when it comes to DB2 DBA functions. But, I'm pretty good at handling any ACB based components and database internals.
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 abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts Get Record count in summary record fo... Atul Banke DFSORT/ICETOOL 21 Fri Sep 23, 2016 4:17 pm
No new posts Select first 2 group data vice_versa DFSORT/ICETOOL 10 Mon Jun 13, 2016 2:21 pm
No new posts How storage is calculated for AN-Edit... Raghu navaikulam COBOL Programming 2 Wed Mar 09, 2016 3:51 pm
No new posts How can amount of the Storage Usage b... esduman61 CICS 6 Wed Mar 09, 2016 1:19 pm


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