How to run a ddl script?

mahendrakariya · #1 (**permalink**) 01-28-09, 08:50

Let me first mention that i am a newbie.

I had developed a database. Before formatting my system, I had generated the ddl script and a backup of the database.

Now i want the same tables and the data that I had earlier.

I tried to run the command db2 -tvf TGMC2008 - DDL
But i am getting SQL5005C System Error.

Kindly guide me. also tell me how to use the backup data.

Marcus_A · #2 (**permalink**) 01-28-09, 09:37

Assume you script is named TGMC2008.DDL and contains the following

Code:

connect to sample;

select * from emp;

alter table emp add column imigration_status smallint;

connect reset;

The run the script with this:

db2 -tvf TGMC2008.DDL > TGMC2008.OUT

Note that in Linux and UNIX, the file names are case sensitive.

MarkhamDBA · #3 (**permalink**) 01-28-09, 10:06

[QUOTE=mahendrakariya]I had developed a database. Before formatting my system, I had generated the ddl script and a backup of the database. Now i want the same tables and the data that I had earlier.
QUOTE]

It might not answer your question but why don't you just restore your db? Then you don't need to create all objects one by one and load tables.

nick.ncs · #4 (**permalink**) 01-28-09, 10:10

DDL scripts will only create your db structure but will have no data....so the best thing is to restore the db

mahendrakariya · #5 (**permalink**) 01-29-09, 08:20

Quote:

Originally Posted by nick.ncs

DDL scripts will only create your db structure but will have no data....so the best thing is to restore the db

Thanks... Can u tell me how can i restore the db. I have the ddl script as well as the backup of the db.

stolze · #6 (**permalink**) 01-29-09, 10:40

Quote:

Originally Posted by mahendrakariya

Thanks... Can u tell me how can i restore the db. I have the ddl script as well as the backup of the db.

You use the RESTORE DATABASE command for that.

mahendrakariya · #7 (**permalink**) 01-30-09, 08:35

Thanks for all this help. But i m still not getting it. The ddl file is named TGMC2008 - DDL.ddl and the backup file is named TGMC2008.0.DB2 -- Backup. The original db name was TGMC2008. I just want to restore it. What command should I use?

sathyaram_s · #8 (**permalink**) 01-30-09, 09:18

If you have a bakcup file, then using RESTORE command will get both the table structures, indexes etc and the data. It is not necessary to run the DDL.

In your original post, you have mentioned about SQL5005C ... That has nothing to do with your ddl or restore ..

Code:

SQL5005C System Error.
Explanation:
A system error, probably an I/O error, was encountered while
accessing a configuration file.
 The command cannot be processed.
User Response:
Resubmit the command.
 If the error persists, check the db2diag.log file for details
and ensure that the configuration file is accessible. If unable
to resolve the problem, contact an IBM Service Representative for
assistance.

stolze · #9 (**permalink**) 01-30-09, 11:41

Quote:

Originally Posted by mahendrakariya

Thanks for all this help. But i m still not getting it. The ddl file is named TGMC2008 - DDL.ddl and the backup file is named TGMC2008.0.DB2 -- Backup. The original db name was TGMC2008. I just want to restore it. What command should I use?

Sorry, I don't understand your question at all. If you search in the DB2 manuals, you will find the "RESTORE" command that all of us are referring to. Is there some problem with using this command?

Marcus_A · #10 (**permalink**) 01-30-09, 11:59

Quote:

Originally Posted by mahendrakariya

Thanks for all this help. But i m still not getting it. The ddl file is named TGMC2008 - DDL.ddl and the backup file is named TGMC2008.0.DB2 -- Backup. The original db name was TGMC2008. I just want to restore it. What command should I use?

The command is:

find experienced DBA

We are not hear to help people who know absolutely nothing about DB2.

przytula_guy · #11 (**permalink**) 01-31-09, 07:24

please be more specific with all questions you ask
we can not see what you are doing or wanting todo
give as much as possible details with a complete scenario and why you want todo this. in that case we might be able to help
at least, have a look at infocenter/books for all possible commands/syntax as they have been created for that purpose

Internet Services

Web Development

Digital Marketing

Consumer Tech