RE: Limiting QUSER DASD

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

I don't think objects in QTEMP count as temporary storage in IBM terminology
so if Crystal reports are actually creating objects there (how???), then you
have a serious challenge on your hands, especially without tools that can
peek into QTEMP (PEX can, but I don't wish that pain upon anyone).

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: RE: Limiting QUSER DASD

Elvis, thanks for the detailed reply.

1. I'm checking this out.  I've changed the QPWFSERVER class to top out
at 1GB.  Odd, that.  DSPCLS displays max temp in MB; CHGCLS lets you
change it in KB.  Anyway, this says it still doesn't enforce a cap on
QTEMP storage.  I'm not sure off-hand if that'll prove to be an issue or
not.