DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)

Vijay Kumar R

DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)

I have below TB created on Segmented TS,

Create TB table-name

(Col A char(7) Not Null,

  Col B varchar(30) Not Null,

  Col C varchar(30) Not Null,

   Col D Date Not Null,

   Col E ….,

   Col F ….,

Constraint constraint-name

PRIMARY KEY

(Col A,

  Col B,

  Col C,

  Col D

)

Commit;

CREATE UNIQUE INDEX index-name

ON table-name

(Col A ASC,

 Col B ASC,

 Col C ASC,

 Col D

)

CLUSTER

PIECESIZE 2G

 

Please advise..

Walter Janißen

AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)
(in response to Vijay Kumar R)
Hi

You can’t use CLUSTER and PIECESIZE together. Remove PIECESIZE and it will work.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Vijay Kumar R <[login to unmask email]>
Gesendet: Montag, 11. Juni 2018 09:50
An: [login to unmask email]
Betreff: [DB2-L] - DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)


I have below TB created on Segmented TS,

Create TB table-name

(Col A char(7) Not Null,

Col B varchar(30) Not Null,

Col C varchar(30) Not Null,

Col D Date Not Null,

Col E ….,

Col F ….,

Constraint constraint-name

PRIMARY KEY

(Col A,

Col B,

Col C,

Col D

)

Commit;

CREATE UNIQUE INDEX index-name

ON table-name

(Col A ASC,

Col B ASC,

Col C ASC,

Col D

)

CLUSTER

PIECESIZE 2G



Please advise..

-----End Original Message-----
Attachments

  • image001.png (2.6k)

Ruediger Kurtz

AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)
(in response to Walter Janißen)
Hi Walter,

a snippet from one of our many indexes:

CREATE UNIQUE
INDEX
<blab la bla >
CLUSTER
BUFFERPOOL <BP>
CLOSE YES
COPY NO
PIECESIZE 1 G
COMPRESS NO;

What am I missing?

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Walter Janißen [mailto:[login to unmask email]
Gesendet: Montag, 11. Juni 2018 09:52
An: [login to unmask email]
Betreff: [DB2-L] - AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)

Hi

You can’t use CLUSTER and PIECESIZE together. Remove PIECESIZE and it will work.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Vijay Kumar R <[login to unmask email]<mailto:[login to unmask email]>>
Gesendet: Montag, 11. Juni 2018 09:50
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)


I have below TB created on Segmented TS,

Create TB table-name

(Col A char(7) Not Null,

Col B varchar(30) Not Null,

Col C varchar(30) Not Null,

Col D Date Not Null,

Col E ….,

Col F ….,

Constraint constraint-name

PRIMARY KEY

(Col A,

Col B,

Col C,

Col D

)

Commit;

CREATE UNIQUE INDEX index-name

ON table-name

(Col A ASC,

Col B ASC,

Col C ASC,

Col D

)

CLUSTER

PIECESIZE 2G



Please advise..

-----End Original Message-----

-----End Original Message-----

Walter Jani&#223;en

AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)
(in response to Vijay Kumar R)
Hi Rüdiger

Indeed! I was convinced that I got the same error message, when I tried to create an index with these clauses, but I am pretty sure that there are restrictions with the usage of PIECESIZE. Currently I can’t remember which ones.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Vijay Kumar R <[login to unmask email]>
Gesendet: Montag, 11. Juni 2018 09:50
An: [login to unmask email]
Betreff: [DB2-L] - DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)


I have below TB created on Segmented TS,

Create TB table-name

(Col A char(7) Not Null,

Col B varchar(30) Not Null,

Col C varchar(30) Not Null,

Col D Date Not Null,

Col E ….,

Col F ….,

Constraint constraint-name

PRIMARY KEY

(Col A,

Col B,

Col C,

Col D

)

Commit;

CREATE UNIQUE INDEX index-name

ON table-name

(Col A ASC,

Col B ASC,

Col C ASC,

Col D

)

CLUSTER

PIECESIZE 2G



Please advise..

-----End Original Message-----
Attachments

  • image001.png (2.6k)

Ruediger Kurtz

AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)
(in response to Walter Janißen)
Hi Walter,

I’ve thought right from the start that there must be some misunderstanding. IIRC, the combination of Piecesize and Partitioned may present a problem, but I could be wrong here.

To come back to the original question posted by Vijay:

Are you sure that you really have posted everything? Could it be that some APPEND may be missing?
From what you’ve posted I can’t see what’s probably gone wrong.

Regards

Rüdiger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Walter Janißen [mailto:[login to unmask email]
Gesendet: Montag, 11. Juni 2018 10:29
An: [login to unmask email]
Betreff: [DB2-L] - AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)

Hi Rüdiger

Indeed! I was convinced that I got the same error message, when I tried to create an index with these clauses, but I am pretty sure that there are restrictions with the usage of PIECESIZE. Currently I can’t remember which ones.

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Vijay Kumar R <[login to unmask email]<mailto:[login to unmask email]>>
Gesendet: Montag, 11. Juni 2018 09:50
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)


I have below TB created on Segmented TS,

Create TB table-name

(Col A char(7) Not Null,

Col B varchar(30) Not Null,

Col C varchar(30) Not Null,

Col D Date Not Null,

Col E ….,

Col F ….,

Constraint constraint-name

PRIMARY KEY

(Col A,

Col B,

Col C,

Col D

)

Commit;

CREATE UNIQUE INDEX index-name

ON table-name

(Col A ASC,

Col B ASC,

Col C ASC,

Col D

)

CLUSTER

PIECESIZE 2G



Please advise..

-----End Original Message-----

-----End Original Message-----

Vijay Kumar R

RE: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)
(in response to Ruediger Kurtz)

Getting same error even after removing PIECESIZE  parameter, Some of the other parameters used are :

Close Yes

Copy NO

Compress NO

Erase NO

GBPCACHE Changed

Ruediger Kurtz

AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusiv
(in response to Vijay Kumar R)
Vijay,

could we please have the full scale of the Create Statements, not just a piece of it, one at a time? SOME of the other parameters clearly are not ALL of them, and hiding information from us for whatever reason may be an obstacle to the solution of your problem.

Ruediger




Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Vijay Kumar R [mailto:[login to unmask email]
Gesendet: Montag, 11. Juni 2018 10:55
An: [login to unmask email]
Betreff: [DB2-L] - RE: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusive)


Getting same error even after removing PIECESIZE parameter, Some of the other parameters used are :

Close Yes

Copy NO

Compress NO

Erase NO

GBPCACHE Changed

-----End Original Message-----

Vijay Kumar R

RE: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusiv
(in response to Ruediger Kurtz)

Here is the complete DDL,

CREATE UNIQUE

        INDEX Index-name
       ON table-name
        (
         Col A ASC
         ,Col B    ASC
         ,Col C   ASC
         ,Col D
        )
USING STOGROUP SGGGGGG
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 5
         PCTFREE 10
         GBPCACHE CHANGED
         CLUSTER
         BUFFERPOOL BPPPPPP
         CLOSE YES
         COPY NO
         PIECESIZE 2 G
         COMPRESS NO

Ruediger Kurtz

AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Excl
(in response to Vijay Kumar R)
Sorry for being not precise enough:

By “the full scale” I actually meant TABLESPACE, TABLE and INDEXES. The DDL you provided seems alright to me.

Ruediger


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Vijay Kumar R [mailto:[login to unmask email]
Gesendet: Montag, 11. Juni 2018 11:18
An: [login to unmask email]
Betreff: [DB2-L] - RE: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Exclusiv


Here is the complete DDL,

CREATE UNIQUE

INDEX Index-name
ON table-name
(
Col A ASC
,Col B ASC
,Col C ASC
,Col D
)
USING STOGROUP SGGGGGG
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 5
PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BPPPPPP
CLOSE YES
COPY NO
PIECESIZE 2 G
COMPRESS NO

-----End Original Message-----

Vijay Kumar R

RE: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Excl
(in response to Ruediger Kurtz)

Below is the complete DDL's,

 

CREATE
      TABLESPACE TSSSSSS
         IN DBBBBBBB
         USING STOGROUP SGGGGGG
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 3
         PCTFREE 10
         GBPCACHE CHANGED
         COMPRESS NO
         TRACKMOD YES
         LOGGED
         SEGSIZE 64
         BUFFERPOOL BPPPPPPPPPPP
         LOCKSIZE ROW
         LOCKMAX 0
         CLOSE YES
         CCSID UNICODE
         MAXROWS 255
     ;
     COMMIT;
     CREATE TABLE table-name
         (
         Col A CHAR(7) NOT NULL
         ,Col B VARCHAR(30) NOT NULL
         ,Col C VARCHAR(30) NOT NULL
         ,Col D DATE NOT NULL
         ,Col E  TIMESTAMP
         ,Col F  CHAR(7)
         ,Col G TIMESTAMP
         ,Col H CHAR(7)
         ,Col I  TIMESTAMP
   ,
           CONSTRAINT constraint-name
           PRIMARY KEY
           (
            Col A
           ,Col B
           ,Col C
           ,Col D
           )
        )
         IN DB.TS
         WITH RESTRICT ON DROP
         CCSID UNICODE
         NOT VOLATILE
         APPEND NO
     ;
     COMMIT;


CREATE UNIQUE
        INDEX Index-name
       ON table-name
        (
         Col A ASC
         ,Col B    ASC
         ,Col C   ASC
         ,Col D
        )
USING STOGROUP SGGGGGG
         PRIQTY -1
         SECQTY -1
         ERASE NO
         FREEPAGE 5
         PCTFREE 10
         GBPCACHE CHANGED
         CLUSTER
         BUFFERPOOL BPPPPP
         CLOSE YES
         COPY NO
         PIECESIZE 2 G
         COMPRESS NO

Roy Boxwell

AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Excl
(in response to Vijay Kumar R)
Are your index columns “real” columns or is one, or more of them, a function?!?!

Roy Boxwell

SOFTWARE ENGINEERING GMBH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

From: Vijay Kumar R [mailto:[login to unmask email]
Sent: Monday, June 11, 2018 11:47 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Excl


Below is the complete DDL's,



CREATE
TABLESPACE TSSSSSS
IN DBBBBBBB
USING STOGROUP SGGGGGG
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 3
PCTFREE 10
GBPCACHE CHANGED
COMPRESS NO
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BPPPPPPPPPPP
LOCKSIZE ROW
LOCKMAX 0
CLOSE YES
CCSID UNICODE
MAXROWS 255
;
COMMIT;
CREATE TABLE table-name
(
Col A CHAR(7) NOT NULL
,Col B VARCHAR(30) NOT NULL
,Col C VARCHAR(30) NOT NULL
,Col D DATE NOT NULL
,Col E TIMESTAMP
,Col F CHAR(7)
,Col G TIMESTAMP
,Col H CHAR(7)
,Col I TIMESTAMP
,
CONSTRAINT constraint-name
PRIMARY KEY
(
Col A
,Col B
,Col C
,Col D
)
)
IN DB.TS
WITH RESTRICT ON DROP
CCSID UNICODE
NOT VOLATILE
APPEND NO
;
COMMIT;

CREATE UNIQUE
INDEX Index-name
ON table-name
(
Col A ASC
,Col B ASC
,Col C ASC
,Col D
)
USING STOGROUP SGGGGGG
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 5
PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BPPPPP
CLOSE YES
COPY NO
PIECESIZE 2 G
COMPRESS NO

-----End Original Message-----

Ruediger Kurtz

AW: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually
(in response to Vijay Kumar R)
Vijay,

unless there’s still something that you don’t show us I’m out of ideas.

I just ran your statements in our environment (okay, we’re V12, but that shouldn’t be the problem) and they finished just fine.

Regards

Ruediger



Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Vijay Kumar R [mailto:[login to unmask email]
Gesendet: Montag, 11. Juni 2018 11:47
An: [login to unmask email]
Betreff: [DB2-L] - RE: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Excl


Below is the complete DDL's,



CREATE
TABLESPACE TSSSSSS
IN DBBBBBBB
USING STOGROUP SGGGGGG
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 3
PCTFREE 10
GBPCACHE CHANGED
COMPRESS NO
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BPPPPPPPPPPP
LOCKSIZE ROW
LOCKMAX 0
CLOSE YES
CCSID UNICODE
MAXROWS 255
;
COMMIT;
CREATE TABLE table-name
(
Col A CHAR(7) NOT NULL
,Col B VARCHAR(30) NOT NULL
,Col C VARCHAR(30) NOT NULL
,Col D DATE NOT NULL
,Col E TIMESTAMP
,Col F CHAR(7)
,Col G TIMESTAMP
,Col H CHAR(7)
,Col I TIMESTAMP
,
CONSTRAINT constraint-name
PRIMARY KEY
(
Col A
,Col B
,Col C
,Col D
)
)
IN DB.TS
WITH RESTRICT ON DROP
CCSID UNICODE
NOT VOLATILE
APPEND NO
;
COMMIT;

CREATE UNIQUE
INDEX Index-name
ON table-name
(
Col A ASC
,Col B ASC
,Col C ASC
,Col D
)
USING STOGROUP SGGGGGG
PRIQTY -1
SECQTY -1
ERASE NO
FREEPAGE 5
PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BPPPPP
CLOSE YES
COPY NO
PIECESIZE 2 G
COMPRESS NO

-----End Original Message-----

Vijay Kumar R

RE: AW: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually
(in response to Ruediger Kurtz)

Hi All - I have provided complete DDL's and only thing I masked is DB,TS, TB , SG and BP names, nothing else.

There are no function names or anything similar. I'm really perplexed and putting on my head through articles and manuals but feeling helpless.

Thanks,

Vijay

Ruediger Kurtz

AW: AW: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutua
(in response to Vijay Kumar R)
A shot in the dark – is any column name by any chance a restricted name?


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon: 09561 96-44148
Telefax: 09561 96-44104
E-Mail: [login to unmask email]
Internet: www.huk.de
________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Vijay Kumar R [mailto:[login to unmask email]
Gesendet: Montag, 11. Juni 2018 12:17
An: [login to unmask email]
Betreff: [DB2-L] - RE: AW: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually


Hi All - I have provided complete DDL's and only thing I masked is DB,TS, TB , SG and BP names, nothing else.

There are no function names or anything similar. I'm really perplexed and putting on my head through articles and manuals but feeling helpless.

Thanks,

Vijay

-----End Original Message-----

Roy Boxwell

AW: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually
(in response to Ruediger Kurtz)
CUBE etc.

Roy Boxwell

SOFTWARE ENGINEERING GMBH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

From: Kurtz, Rüdiger [mailto:[login to unmask email]
Sent: Monday, June 11, 2018 12:56 PM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - AW: AW: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually

A shot in the dark – is any column name by any chance a restricted name?


Rüdiger Kurtz
Abteilung Informatik – Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg
Telefon:

09561 96-44148

Telefax:

09561 96-44104

E-Mail:

[login to unmask email]<mailto:[login to unmask email]>

Internet:

www.huk.de http://www.huk.de

________________________________
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Prof. Dr. Heinrich R. Schradin.
Vorstand: Klaus-Jürgen Heitmann (Sprecher), Stefan Gronbach, Dr. Hans Olav Herøy, Dr. Jörg Rheinländer (stv.), Sarah Rössler, Daniel Thomas.
________________________________
Diese Nachricht enthält vertrauliche und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese Nachricht irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Nachricht.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Nachricht ist nicht gestattet.

This information may contain confidential and/or privileged information.
If you are not the intended recipient (or have received this information in error) please notify the
sender immediately and destroy this information.
Any unauthorized copying, disclosure or distribution of the material in this information is strictly forbidden.
________________________________
Von: Vijay Kumar R [mailto:[login to unmask email]
Gesendet: Montag, 11. Juni 2018 12:17
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: AW: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually


Hi All - I have provided complete DDL's and only thing I masked is DB,TS, TB , SG and BP names, nothing else.

There are no function names or anything similar. I'm really perplexed and putting on my head through articles and manuals but feeling helpless.

Thanks,

Vijay

-----End Original Message-----

-----End Original Message-----

James Campbell

AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Excl
(in response to Vijay Kumar R)
Put quotes (or apostrophes if that is your SQL string delimiter) around each name. If the
create succeeds you have used a reserved word.

Then add DEFINE NO. Will make the following go a bit quicker.

Take clauses out - first COMPRESS. then COMPRESS and PIECESIZE, then ...

When the create succeeds you have found the one that creates the error.

Given the range of choices in bufferpool names, I think hiding the actual name is a little
extreme.

James Campbell


On 11 Jun 2018 at 2:46, Vijay Kumar R wrote:

>
> Below is the complete DDL's,
>  
<snip>
>
> CREATE UNIQUE
>         INDEX Index-name
>        ON table-name
>         (
>          Col A ASC
>          ,Col B    ASC
>          ,Col C   ASC
>          ,Col D
>         )
> USING STOGROUP SGGGGGG
>          PRIQTY -1
>          SECQTY -1
>          ERASE NO
>          FREEPAGE 5
>          PCTFREE 10
>          GBPCACHE CHANGED
>          CLUSTER
>          BUFFERPOOL BPPPPP
>          CLOSE YES
>          COPY NO
>          PIECESIZE 2 G
>          COMPRESS NO
>
>



---
This email has been checked for viruses by AVG.
https://www.avg.com

Vijay Kumar R

RE: AW: AW: AW: DB2 ZOS, V11 CREATE UNIQUE INDEX failing with SQLCODE -628(The clauses are Mutually Excl
(in response to James Campbell)

we were using Restricted column names, we changed the column names and it worked fine.

Thanks all for your valuable propositions.