RE: Overriding the defaults of a sql command.

I am still transitioning from the mindset of a DDS shop. In a DDS shop
you have QDDSSRC. And you do your CRTPF from that. Transitioning shops
may have QSQLSRC and use RUNSQLSTM on that. So, in theory, you could have
one QSQLSRC producing both your PRODuction schema and your TEST schema.

An alternative is to periodically review

-- disk_type: 1=SSD, 0=not SSD
select distinct system_table_schema, system_table_name, unit_type, 'CHGPF'
as command
from qsys2.syspartitiondisk
where system_table_schema<>'PROD' and unit_type='1'
union all
select distinct system_index_schema, system_index_name, unit_type, 'CHGLF'
as command
from qsys2.syspartitionindexdisk
where system_table_schema<>'PROD' and unit_type='1'
order by 1,2;

or some such thing and process accordingly.

We even have a UDF to run the command shown in the text.


Rob Berendt