Online reorg with inline colgroup histograms stats BOTH keyword getting ignored for INDEX ALL

Hello everybody,

kindly someone share your thoughts on the below error.
I ran the online reorg job with inline colgroup histograms stats BOTH keyword getting ignored for INDEX ALL .

Details :-

DB2 Z/os V12

'DSNU073I 150 XX:XX:XX.XX DSNUGPPM - KEYWORD 'BOTH' IGNORED'

stat-index-spec:-

STATISTICS
TABLE(OWNER.TABLE1) SAMPLE 25
COLUMN(ALL)
COLGROUP("C1")
FREQVAL (COUNT 10 BOTH)
HISTOGRAM NUMQUANTILES 100
COLGROUP("C2")
FREQVAL (COUNT 10 BOTH)
HISTOGRAM NUMQUANTILES 100
INDEX(ALL
FREQVAL NUMCOLS 1 COUNT 10 BOTH
FREQVAL NUMCOLS 2 COUNT 10 BOTH
FREQVAL NUMCOLS 3 COUNT 10 BOTH
FREQVAL NUMCOLS 4 COUNT 10 BOTH
FREQVAL NUMCOLS 5 COUNT 10 BOTH)
HISTOGRAM NUMCOLS 1 NUMQUANTILES 100
HISTOGRAM NUMCOLS 2 NUMQUANTILES 100
HISTOGRAM NUMCOLS 3 NUMQUANTILES 100
HISTOGRAM NUMCOLS 4 NUMQUANTILES 100
HISTOGRAM NUMCOLS 5 NUMQUANTILES 100
REPORT NO



Thanks

Raj

Views: 16

Reply to This

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

IDUG NA 2019 in Charlotte: RUG Leaders Luncheon on Tue, 4th, June.

Posted by Manuel Gomez Burriel on May 30, 2019 at 7:23 1 Comment

IDUG are pleased to once again invite all Db2 Regional User Group (RUG) leaders attending the IDUG conference in Charlotte to join us for a RUG Leaders Luncheon on Tuesday, June 4,…

Continue

Videos

  • Add Videos
  • View All

IDUG Conference News

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service