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: 44

Reply to This

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

Forum

Db2 for z/OS Master class with John Campbell and the SWAT team returns!

Started by Surekha Parekh in What's hot ?. Last reply by carol Goldberg Nov 7. 1 Reply

Db2 for z/OS Master class with John Campbell and the SWAT team returns! June 24-28, 2019 at IBM Hursley near Winchester, UKSeptember 23-27, 2019 at IBM Silicon Valley Lab in San Jose, California…Continue

Tags: Events, MasterClass, JohnCampbell

RBS Shares their Db2 Utilities Experiences

Started by Calene Janacek in What's hot ? Oct 22. 0 Replies

Join Mark Turner, Lead Mainframe Architect and Strategist from RBS and Haakon Roberts, IBM DE as they share Royal Bank of…Continue

Tags: #Db2

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service