Vendor Product with Dynamic DB2 Table Build Process

Lizette Koehler

Vendor Product with Dynamic DB2 Table Build Process
I have been out of DB2 for a while but I have not heard of a process to build DB2 tables and tablespaces dynamically.

Could someone point me to a manual and section that deals with this process?

Background
A vendor product has parm inputs that just specify the TSname and TBname. It does not have any DB2 definitions for the table, it does not have any sample job to LOAD the table, and I do not find any DLL statements.

So I am thinking that it will talk to DB2 tell it what it needs for the table, columns and column definitions and the DBA part is not needed.

I am just trying to understand somethign that looks like a dynamic build and load between DB2 and this product.

I am use to having to provide the DBAs with the information so that my security group and DBA group know the table/ts and its requirements. This is kinda new to me.

Thanks


Lizette

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Carol Anne Sutfin

Re: Vendor Product with Dynamic DB2 Table Build Process
(in response to Lizette Koehler)
Lizette,

Vendors have found many "clever" and devious ways to create tables both
dynamically and by generating the DDL themselves and running it
internally.
I think that they just do want you to know what they are doing.

Even more fun is if you insist on using standard naming conventions.

You need to gently insist that you see the DDL before running it.

I recently had one vendor application that attempted to allocate all of
the tablespaces with a PRIQTY of 4G.
I had to explain why they could not get all of that DASD in large
allocations.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



From: Lizette Koehler <[login to unmask email]>
To: [login to unmask email]
Date: 12/29/2010 04:09 PM
Subject: [DB2-L] Vendor Product with Dynamic DB2 Table Build
Process
Sent by: IDUG DB2-L <[login to unmask email]>



I have been out of DB2 for a while but I have not heard of a process to
build DB2 tables and tablespaces dynamically.

Could someone point me to a manual and section that deals with this
process?

Background
A vendor product has parm inputs that just specify the TSname and TBname.
It does not have any DB2 definitions for the table, it does not have any
sample job to LOAD the table, and I do not find any DLL statements.

So I am thinking that it will talk to DB2 tell it what it needs for the
table, columns and column definitions and the DBA part is not needed.

I am just trying to understand somethign that looks like a dynamic build
and load between DB2 and this product.

I am use to having to provide the DBAs with the information so that my
security group and DBA group know the table/ts and its requirements. This
is kinda new to me.

Thanks


Lizette

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: Vendor Product with Dynamic DB2 Table Build Process
(in response to Carol Anne Sutfin)
Are you telling me there's no installation parameter to say to that
product to 'explicit' define a TS/TB via 'visible' DDL ? But how does it
know columns values etc...from pgms ? Packages ? Or what ?

It's strange and not well-built for DBAs.

But who knows, in the past I saw a product generating SQLs statements in a
crazy way, but at least you colud see those statements

Max Scarpa

Certified 'Year 2011 will be the right year' DB2 sysprog



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Lizette Koehler

Re: Vendor Product with Dynamic DB2 Table Build Process
(in response to Max Scarpa)
Carol,





I feel concerned that I have no control over the allocation of the TS/TB. That I cannot set up parameters (as far as I can tell) for GBP etc. and the lack of DDL is a problem. Once I get more information from the vendor, I will post further observations.



My DBAs and I like having a bit more control over allocation and parms to ensure proper running of the TB/TS along with performance. I realize the vendor it just trying to simplify the product for shops that may not have the expertise in this area, but I do not believe they should take it away from those of us that need to have the control.



Thanks for the advice and letting me know I am not missing some subtle change in DB2 activities.



Lizette





From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Wednesday, December 29, 2010 5:53 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Vendor Product with Dynamic DB2 Table Build Process



Lizette,

Vendors have found many "clever" and devious ways to create tables both dynamically and by generating the DDL themselves and running it internally.
I think that they just do want you to know what they are doing.

Even more fun is if you insist on using standard naming conventions.

You need to gently insist that you see the DDL before running it.

I recently had one vendor application that attempted to allocate all of the tablespaces with a PRIQTY of 4G.
I had to explain why they could not get all of that DASD in large allocations.

Carol Sutfin
Corporate DBA
Regions Financial Corp.
(205)261-5214
[login to unmask email]



From: Lizette Koehler <[login to unmask email]>
To: [login to unmask email]
Date: 12/29/2010 04:09 PM
Subject: [DB2-L] Vendor Product with Dynamic DB2 Table Build Process
Sent by: IDUG DB2-L <[login to unmask email]>

_____




I have been out of DB2 for a while but I have not heard of a process to build DB2 tables and tablespaces dynamically.

Could someone point me to a manual and section that deals with this process?

Background
A vendor product has parm inputs that just specify the TSname and TBname. It does not have any DB2 definitions for the table, it does not have any sample job to LOAD the table, and I do not find any DLL statements.

So I am thinking that it will talk to DB2 tell it what it needs for the table, columns and column definitions and the DBA part is not needed.

I am just trying to understand somethign that looks like a dynamic build and load between DB2 and this product.

I am use to having to provide the DBAs with the information so that my security group and DBA group know the table/ts and its requirements. This is kinda new to me.

Thanks


Lizette

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * < http://idug.org/NA > http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, < http://www.idug.org/cgi-bin/wa?A0=DB2-L > http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv



_____

< http://www-01.ibm.com/software/data/db2/zos/db2-10/ > Introducing IBM® DB2® 10 for z/OS

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

James Campbell

Re: Vendor Product with Dynamic DB2 Table Build Process
(in response to Lizette Koehler)
Here is the link you asked for

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?Topic=/com.ibm.db29.doc.intro/db2z_creationofdatabases.htm
Jim Campbell
Sr. Database Administrator
Administrative Office of the Courts (AOC)
360-704-4015 (voice plus voice-mail)
[login to unmask email]<mailto:[login to unmask email]>



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Lizette Koehler
Sent: Wednesday, December 29, 2010 2:10 PM
To: [login to unmask email]
Subject: [DB2-L] Vendor Product with Dynamic DB2 Table Build Process



I have been out of DB2 for a while but I have not heard of a process to build DB2 tables and tablespaces dynamically.



Could someone point me to a manual and section that deals with this process?



Background

A vendor product has parm inputs that just specify the TSname and TBname. It does not have any DB2 definitions for the table, it does not have any sample job to LOAD the table, and I do not find any DLL statements.



So I am thinking that it will talk to DB2 tell it what it needs for the table, columns and column definitions and the DBA part is not needed.



I am just trying to understand somethign that looks like a dynamic build and load between DB2 and this product.



I am use to having to provide the DBAs with the information so that my security group and DBA group know the table/ts and its requirements. This is kinda new to me.



Thanks





Lizette



_____________________________________________________________________

* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *

* Your only source for independent, unbiased, and trusted DB2 information. *

** DB2 certification -> no additional charge

** Meet fellow DB2 users and leading DB2 consultants

_____________________________________________________________________



If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

James Campbell

Re: Vendor Product with Dynamic DB2 Table Build Process
(in response to James Campbell)

Here is the link you asked for

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?Topic=/com.ibm.db29.doc.intro/db2z_creationofdatabases.htm

Jim Campbell
Sr. Database Administrator
Administrative Office of the Courts (AOC)
360-704-4015 (voice plus voice-mail)
[login to unmask email]



The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.