By reading this forum, I now understand that you can create an index on a global temporary table in Version 8. Now I need to know how to runstat the global temporary table after I create the index and insert the data into it.

db2 => declare global temporary table session.t_test ( v_alder char (1))
DB20000I The SQL command completed successfully.
db2 => commit
DB20000I The SQL command completed successfully.
db2 => runstats on table session.t_test
DB20000I The RUNSTATS command completed successfully.

thanks for your help, it is much appreciated