I'm trying to optimize CPU consomption. I have a DB2 batch that invoke physical accessor that contains database query. When i run this batch: i have a CPU consumption of 30%.
I want now to eleminate the access to physical accessor and write all query on my batch. My batch run correctly but CPU consumption has increased to 50%. I'm surprized.
Is there a compile way to compile my batch with ? Why writing query directly on batch have increased the CPU consumption ?