Is there any way with db2look, or perhaps with some other system command, where you can see the exact command structure that created a database?

Hi DB2 gurus,

This question was asked sometime ago sometime ago. I was never able find the answer. So let me ask again. There are various options for db2look you can use to see the DDL for just about every object in the database except the command that created the database itself. Is there any way with db2look, or perhaps with some other system command, where you can see the exact command structure that created a database?

Thank you.

Enyimba
EnyimbaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
MurpheyApplication ConsultantCommented:
For db2/400 ther is a retrieve sql function in the iSeries Navigator.
other db2 versions. I do not know
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
0
 
Carlos IjalbaSenior SysadminCommented:
In DB2 all the info is extracted via db2look, in fact navigator also uses db2look for it's retrieve SQL functions.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
EnyimbaAuthor Commented:
Hi Gary Patterson,

I've been a little sick this past several days. So I pick up from Gary's suggestion. tried to use the -createdb but got an error..."The option "-createdb" is not supported by db2look."
Perhaps you could share with me where you got the -createdb command option.

Thanks

Enyimba
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
From the manual.  I provided you a link in my first post.  -createdb options is available stating in v10.  Are you running an old version of DB2?
0
 
EnyimbaAuthor Commented:
Gary, I just tried to use the command prior to posting...here's the syntax that I used...

db2look -d db_name -e  -createdb -l -o file.out    and lo and behold this is what I got. Perhaps I am doing somethingwrong?
apmq02hdqra /home/rapmq01i/workdir >db2look -d db_name -e  -createdb -l -o file.out

The option "-createdb" is not supported by db2look.

Syntax: db2look -d DBname [-e] [-xs] [-xdir Path] [-u Creator] [-z Schema]
                          [-t Tname1 Tname2...TnameN] [-tw Tname] [-xdep] [-xddep]
                          [-o Fname] [-a] [-m] [-c] [-r] [-l] [-x] [-xd] [-f] [-h]
                          [-fd] [-td x] [-noview] [-i userID] [-w password]
                          [-v Vname1 Vname2 ... VnameN] [-dp] [-ct]
                          [-wrapper WrapperName] [-server ServerName] [-nofed]
                          [-wlm] [-ap] [-mod] [-cor] [-wrap] [-noimplschema] [-nostatsclause]
                          [-wrapper WrapperName] [-server ServerName][-fedonly] [-nofed]
0
 
Carlos IjalbaSenior SysadminCommented:
Enyimba,

Under what OS are you running DB2? because not all the commandset of DB2 is available for AS/400 for example, but it is for UNIX.

So it is important to know and look at the appropriate documentation, Gary's book is for DB2 for Linux/Windows.
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
Question tag says "DB2 LUW", so I've been operating on the assumption that this is DB2 LUW.  BIgger question for me is "what version"?  Looks to me like this must be an older version of DB2 that doesn't support the -createdb option.

-createdb option was introduced in DB2 10.1 Fixpack 4

http://blog.4loeser.net/2014/06/improved-db2look-in-db2-to-mimick.html
0
 
EnyimbaAuthor Commented:
Hi all

I am running DB2 10.3 in a Unix/AIX 7.1 environment and that is where that command was issued and errored out.

Thanks


Enyimba.
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
As far as I know, there is no such release as DB2 10.3 for LUW.  IBM went from 10.1 to 10.5.  Any chance you mean v10.1 Fixpack 3?  If so, then you just need to Fixpack 4 to get the db2look -createdb option:

http://www-01.ibm.com/support/docview.wss?uid=swg27007053
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
EnyimbaAuthor Commented:
General answers but no definitive example of use of -created db2look option
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
You supplied a "definitive example" yourself.  Your syntax was  correct:

db2look -d db_name -e  -createdb -l -o file.out

Your syntax is not the problem.  The problem is that you are running an older version of db2look that doesn't support the -createdb option.  If you applied the fixpack I recommended then the command you attempted earlier should work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.