Hi folks,

Is it possible to create a task right from the DB2 CLP instead of
using the IBM Task Center (GUI) ?

DB2 DEV server : DB2 Express-C / Windows 2008 Server Standard Edition
DB2 PROD server : DB2 9.5 Workgroup / Windows 2008 Server Standard
Edition

Thank you and have a great day!

Charles M.

You might want to check out the ADMIN_TASK_ADD procedure.

http://bit.ly/hVJbw7

Hope this helps.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

Hello Helmut,

I already tried that command. That "works" but the task is not showing
up in the Task Center.

I would like to create a scheduled task that would work AND show up in
the Task Center.

I wished there was a "Show command" button in the Task Center just
like in the IBM Control Center.

Is it possible?

Thanks

Charles

On 9 déc, 17:50, Helmut Tessarek <tessa... (AT) evermeet (DOT) cx> wrote:

The question is why would you want to create tasks without using the
task center? Unless you want to script it and make up hundred of
similar jobs.

I do find it annoying that the Task Center won't let you clone a job.
If you have to back up 100 dbs you have to re-enter info everytime. It
would be nice to be able to bring up a job (task), modify and save as
new job.

Well,

I want to add the task creation command at the end of my database
creation script, so my developers won't forget to schedule a backup
job.

Our backup strategy works as follow :
- 10PM : Task Center runs the backup job to E:\BACKUP
- 12AM : HP Data Protector takes the backup archive on E:\BACKUP and
saves it on a tape

I would like to script it and also be able to view activte jobs in the
Task Center.

Thanks for help

Charles

Just had another idea...

Would it be possible to create a kind of cursor that would loop
through all databases in an instance and then issue the BACKUP
command?

That way my problem would be solved with one single dynamic task.

On Dec 10, 7:03*am, "Charles M." <charley... (AT) gmail (DOT) com> wrote:
Task Center and the DB2 Administration Server are deprecated in DB2
9.7 -- its functionality is being replaced by the administrative task
scheduler that's built directly into the engine.

Helmut is describing the interface to this new feature.

You can read about the administrative task scheduler here:
http://publib.boulder.ibm.com/infoce.../c0054380.html

Good stuff.

Thanks for the information Ian.

Much appreciated.

Have a great day

Charles

On 2010-12-10 15:49, Charles M. wrote:
Not sure about Windows (I assume it is possible though), but in a unix
shell you can loop over the db's in an instance as:

for db in `db2 list db directory | grep -B4 "Directory entry type
= Indirect" | grep "Database name" | cut -f2 -d= | sort -u`;
do db2 "backup db $db ..." done

Just an example. Another thing that comes to mind is to dump the content
of the task center db before and after you schedule a backup and see
what the difference is. You will of course have to keep track of changes
of the schema in this db between fixpaks etc, and maintain your scripts
accordingly

Just some random thoughts

/Lennart

On 11 dec, 08:50, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com>
wrote:
Hey,

I just want to note that taking offline backups will probably be
difficult using ATS. He can always take offline backups using the
autonomic maintenance configuration:
http://www.ibm.com/developerworks/da...san/index.html

It depends on what he needs of course, but I'd go for a scheduled job
as well.

--
Frederik