||Using SQL to generate SQL for Administrating an Informix Database Server|
||Lester Knutsen has been developing database applications
databases since 1983. He is president of Advanced
DataTools, an IBM
Informix Consulting, Training, Support and Tools Partner
specializing in data
warehouse development, database design, performance
tuning, and Informix
training and support.
Currently, Lester specializes in Informix performance
Informix training and developing very fast database
systems. He provides
training and consulting in database design and
performance tuning, and is
widely known in the Informix community for his extensive
Lester is founder and past president of the Washington
D.C. Area Informix
Users Group, and is one of the five founding members of
Informix Users Group. Lester is also a member of the IBM
program and in October 2008 was awarded one of the
Champion awards by IBM.|
|As DBA's we create scripts to perform DBA functions all the
time. This presentation is on tips and tricks for using SQL to generate SQL scripts and KSH scripts to perform certain repetitive DBA functions.
I will show examples of SQL scripts generating scripts to grant or revoke privileges, alter table attributes table, replicate dbspace, chunk and server configuration setting.