Forum top experts: please take notice!!!

[blom0344]

A bit of a dramatic way to get attention, but i'm still searching for some examples concerning stored procedures for dropping and re-creating indexes.

I'm using Powermart to fill and update datamarts, with some tables writing and updating data is criminally slow. I want to try pre-session triggering of a stored procedure that will drop the index , to increase inserts and updates in the target table.

Anyone any examples , ideas , sites , books , publications ?

T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[v0520]

you could use the stored procedure to trigger a "batch process" which contains the drop statements you desire.

For example, I have written stored procedures in the mainframe environment where I write to the internal reader.
You must allocate an //intrdr dd statement to the stored procedures address space though.

If you are running on mainframe, let me know and I can show you how to trigger batch jobs from stored procedures. Gilbert M. Vanegas
Programmer Analyst III
County of San Bernardino - ISD
Email : gvanegas@isd.sbcounty.gov

 

[blom0344]

Hello Gilbert,

Thanks for your reaction.

Actually i'm in the business of datawarehousing and have a number of databases on DB2 UDB 7.1 running on NT server.

So I guess that's not comparable with a mainframe environment and routines.

T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com