Yes, it is compatible with db2set -im
------------------------------
Madhusudan S M
------------------------------
Original Message:
Sent: Mon November 10, 2025 08:50 AM
From: malek shabou
Subject: DB2 12.1.3, MODEL_JOIN_CARD
thank you,
is it compatible with db2set -im or i need to restart the instance ?
Best regards,
------------------------------
malek shabou
Original Message:
Sent: Mon November 10, 2025 08:04 AM
From: Madhusudan S M
Subject: DB2 12.1.3, MODEL_JOIN_CARD
Please DB2_SELECTIVITY=MODEL_JOIN_CARD ON
------------------------------
Madhusudan S M
Original Message:
Sent: Mon November 10, 2025 06:31 AM
From: malek shabou
Subject: DB2 12.1.3, MODEL_JOIN_CARD
Hello,
DB2 12.1.3 support cardinality models for join predicate selectivity estimation (Changed functionality in Db2 12.1.3) the documentation dont say if we need to put:
DB2_SELECTIVITY="MODEL_JOIN_CARD" or DB2_SELECTIVITY="MODEL_JOIN_CARD=YES"
i'am looking for the limit of MODEL_JOIN_CARD.
Best regards,
------------------------------
malek shabou
------------------------------