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

Reply to This

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

Forum

Creating a function in DB2

Started by Jacob Ruchotzke in What's hot ? Jun 18. 0 Replies

With the help of our IT guy i have sort of gotten an example of how to create a function in our system. Can anyone help me with this? Please see the attached SQL file.Thanks in advanceContinue

Tags: function

Conversion of BLOB to String/ Text

Started by Jitesh Audichya in Application Development and DB2. Last reply by Jitesh Audichya Apr 24. 2 Replies

Hi All,Problem Statement:I have a field with BLOB data type in DB2 database, I want to extract this blob and convert it to Text. The text data after the conversion will be in Japanese characters. How can I write a select with the conversion from…Continue

Tags: on, DB2, conversion, text, to

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service