Help with IBM DB2 DBMS

I am newbie with IBM DB2 DBMS.

I need to write some commands below.

Somebody please help me?

Thank you very much!


1. Give a set of commands to create a database name TEST1 in schema DB2ADMIN with the following specification

- Use only 1 default buffer pool IBMDEFAULTBP, having page size of 32K.
- Tablespace for user data: USERSPACE1 for Large data type, using IBMDEFAULTBP, Managed by Database, NOT using Automatic Storage, and is Auto-resizable.


2. Give a set of commands to create a compressed offline backup of the TEST1 database above.


3. Give a set of commands to create a clone of TEST1, called TEST2, in the same DB2 instance, using the backup created in the step above. The TEST1 database must remain functioning.
JameMeckAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Kent OlsenDBACommented:
Hi Jame,

Please forgive the question, but the questions look remarkably like homework/classwork kinds of questions.  Is this as assignment or do you have specific needs for the items you've described?  The reason I ask is so that we can stay on the correct side of EE's rules on academic integrity.

The questions also indicate that some basic information is in order.  :)

>> 1. Give a set of commands to create a database name TEST1 in schema DB2ADMIN with the following specification

This is a trick question.  :)  

The hierarchy is server, instance, schema.  On the server, you can run 1 or more copies of DB2.  These copies are called an "instance".  Each copy of DB2 manages only the items that are registered to that copy.  In most environments, only 1 copy of DB2 will be running, hence only 1 instance.

Within each instance are multiple databases.  In this case, database is nearly synonymous with schema.  You can have lots of schemas, but they are peers.  They all have the same level in the logical hierarchy.  Data and queries can span across multiple schemas.

By default, a DB2 user gets a schema that is his logon ID.  Additional schemas can also be created.

So for this question, the answer is "you can't".  You can create database TEST1 on the instance owned (managed) by user DB2ADMIN, but you can't create the database (schema) in the DB2ADMIN schema.


Kent

Experts Exchange Solution brought to you by

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
JameMeckAuthor Commented:
Dear Kdo,

I am learning IBM DB2 by myself from begining, these question from the book and my friends. Surely not homework it is as an assignment for my job.

And I think there isn't any trick here, just sample question for a beginner like me.

Anyway, if nobody help me with this, I have to read more from the book.

Thank you very much for your help!
MurpheyApplication ConsultantCommented:
Hi JameMeck,

if nobody help me with this

Wrong assumption Jame,  KDO helped you more then you think, its NOT possible to create something in schema DB2ADMIN.
DB2ADMIN is the admin schema and you can't use that.

so he is right, its a trick question.

And because of this answer, the answer on the other questions are "see answer on Q1".

Regards,
Murph
JameMeckAuthor Commented:
Dear sir, I understood the problem.

Thank you very much!
Kent OlsenDBACommented:
Hi Jame,

I thought that the questions you'd asked were asked by someone else and you were tasked with getting the answers, hence my reference to a "trick question".

There's certainly nothing tricky about your asking questions here!  :)


Kent
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.