View previous topic :: View next topic
|
Author |
Message |
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Is there not a storage management group for such things? |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
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 |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Congrats on getting this working
We definitely appreciate the followup and you posting the solution.
We'll be here if there are any other "adventures".
d |
|
Back to top |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
Just an FYI for all the help I have received, creation of this database is needed to drive this SQL: 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 |
|
|
|