RE: Overriding the defaults of a sql command.

[rob@xxxxxxxxx]

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