Slow response with first online interaction of the day

Every morning the first person in will log into PassPort. The user proceeds to the D930 panel. The response time, just the first one every morning, takes 5 to 8 minutes and at times experience timeouts. Once the
panel's data is retrieved it works fine all day. It is just that first time every morning for the past few months. Nothing changed as far as servers or users. No batch is running at that time. Just looking for something we can look at or check into. Any suggestions?

Are the database indexes for table TIDPBOOK OK?

Hi,

Is there any indication that the indexes for table TIDPBOOK have outgrown their space allocations?

Is the database DB2? If so, has there been a change in the database related to using statistics when a bind is done? Perhaps a change in when and how statistics are being generated? Can a rebind be done in the PassPort region of tigpboo5.csm?

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.