It's a non-unique index on a PBG CREATE INDEX ... ON table (MANDT ASC, APPL_ID ASC, GROUP_ID ASC, EXPOBJKEY ASC) NOT PADDED USING STOGROUP SYSDEFLT PRIQTY 720000 SECQTY -1 ERASE NO FREEPAGE 1 PCTFREE 10 GBPCACHE CHANGED NOT CLUSTER COMPRESS ...
Was it a UNIQUE index by any chance? Or was it a DPSI? Roy Boxwell SOFTWARE ENGINEERING GmbH and SEGUS Inc. -Product Development- Vagedesstrasse 19 40479 Dusseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de ...
All, We have some really, seriously large DB2 bufferpools.... Some are defined as PGSTEAL(NONE), but obviously, this is not viable for all pools. We DO utilize the larger pageframe sizes MB & GB in our pools & have set PGSTEAL(FIFO) ...
Please join us this Friday June 18 for the last show of #db2night season 12. Guest Tony Andrews of Themis will present his favorite Db2 z/OS performance features. Register at: https://register.gotowebinar.com/register/1237606305005797902 ...
Thank you, Dan :-) Philip Sevetson Computer Systems Manager FISA-OPA 5 Manhattan West New York, NY 10001 psevetson@fisa-opa.nyc.gov 917-991-7052 m 212-857-1659 f
Looking forward to seeing you again. We have 2 great topics, one for DBA's and one for Developers. ...