5958 Warning: A partitioning expression or join index search condition is nondeterministic.
A partitioning expression in a CREATE TABLE, ALTER TABLE, or CREATE JOIN INDEX or search condition in a CREATE JOIN INDEX was found to be nondeterministic. Queries that are executed with partition elimination may get wrong results and rows may be improperly partitioned. This warning indicates the table was created in an earlier release with a partitioned primary index where one or more of the partitioning expressions were nondeterministic. Note that nondeterministic partitioning expressions are not supported (a partitioning expression must be deterministic) but an error was not reported in all cases in earlier releases.
End User and System Support Representative.
This is a warning but it is important to follow the instructions in the following remedy to make sure the rows are correctly partitioned.
It is recommended that you contact your System Support Representative to assist in applying this remedy. Recreate the table with deterministic partitioning and repopulate. The rows for the original table can be insert-selected from the original table into the new table or if there is not enough space on the system, the new table may be repopulated from a backup. If you run all maintenance, queries, and ALTER TABLE statements for this table in the same session time zone, session collation and session mode (ANSI or BT/ET), rows may be okay in the table and you may decide to delay applying this remedy; however, it is highly recommended to apply the remedy at the soonest opportunity.