​I'm new to Optim. We're on v11.3.0.6.

My first assignment with this tool is to come up with a test copy of a production Netezza database with masked and/or obfuscated PII fields.

I've figured out a lot of things and have had success but, the Optim functions don't work with NVARCHAR data types. I've had to have our DBA make copies of tables with NVARCHAR data types converted to VARCHAR. Then I can run all the Optim functions I need successfully. Finally the DBA copies the modified table VARCHAR data types back to NVARCHAR. I have the same requirement using SQL Server databases.

IBM hasn't been able to tell me whether NVARCHAR data types will be convertible in future versions but my feeling is that it isn't high on their list.

For clarification VARCHAR is ASCII and NVARCHAR is UTF-8.

Now my question; is that what everyone else is doing? If I submit a Request for Enhancement, is anyone else here interested in supporting that request?

------------------------------
Glenn Cameron
------------------------------

#InfoSphereOptim
#Optim

Hi Glenn,

We are aware of this problem and fixed on 11.3.0.5 but no iFix #045 is available on 11.3.0.6 due to the fact 11.3.0.6 released before this fix. Please open a PMR to create the same fix on 11.3.0.6.

Hope that helps.

Thanks,​

------------------------------
Tulasi Uppu
------------------------------

Original Message:
Sent: 10-26-2018 14:27
From: Glenn Cameron
Subject: Optim functions and NVARCHAR

​I'm new to Optim. We're on v11.3.0.6.

My first assignment with this tool is to come up with a test copy of a production Netezza database with masked and/or obfuscated PII fields.

I've figured out a lot of things and have had success but, the Optim functions don't work with NVARCHAR data types. I've had to have our DBA make copies of tables with NVARCHAR data types converted to VARCHAR. Then I can run all the Optim functions I need successfully. Finally the DBA copies the modified table VARCHAR data types back to NVARCHAR. I have the same requirement using SQL Server databases.

IBM hasn't been able to tell me whether NVARCHAR data types will be convertible in future versions but my feeling is that it isn't high on their list.

For clarification VARCHAR is ASCII and NVARCHAR is UTF-8.

Now my question; is that what everyone else is doing? If I submit a Request for Enhancement, is anyone else here interested in supporting that request?

------------------------------
Glenn Cameron
------------------------------

#InfoSphereOptim
#Optim

​Thank you. I've submitted a PMR with that request.

------------------------------
Glenn Cameron
------------------------------

Original Message:
Sent: 10-29-2018 05:11
From: Tulasi Uppu
Subject: Optim functions and NVARCHAR

Hi Glenn,

We are aware of this problem and fixed on 11.3.0.5 but no iFix #045 is available on 11.3.0.6 due to the fact 11.3.0.6 released before this fix. Please open a PMR to create the same fix on 11.3.0.6.

Hope that helps.

Thanks,​

------------------------------
Tulasi Uppu

Original Message:
Sent: 10-26-2018 14:27
From: Glenn Cameron
Subject: Optim functions and NVARCHAR

​I'm new to Optim. We're on v11.3.0.6.

My first assignment with this tool is to come up with a test copy of a production Netezza database with masked and/or obfuscated PII fields.

I've figured out a lot of things and have had success but, the Optim functions don't work with NVARCHAR data types. I've had to have our DBA make copies of tables with NVARCHAR data types converted to VARCHAR. Then I can run all the Optim functions I need successfully. Finally the DBA copies the modified table VARCHAR data types back to NVARCHAR. I have the same requirement using SQL Server databases.

IBM hasn't been able to tell me whether NVARCHAR data types will be convertible in future versions but my feeling is that it isn't high on their list.

For clarification VARCHAR is ASCII and NVARCHAR is UTF-8.

Now my question; is that what everyone else is doing? If I submit a Request for Enhancement, is anyone else here interested in supporting that request?

------------------------------
Glenn Cameron
------------------------------

#InfoSphereOptim
#Optim

Yes, I got that PMR and most likely you will get the fix in another couple of days.

------------------------------
Tulasi Uppu
------------------------------

Original Message:
Sent: 11-08-2018 09:11
From: Glenn Cameron
Subject: Optim functions and NVARCHAR

​Thank you. I've submitted a PMR with that request.

------------------------------
Glenn Cameron

Original Message:
Sent: 10-29-2018 05:11
From: Tulasi Uppu
Subject: Optim functions and NVARCHAR

Hi Glenn,

We are aware of this problem and fixed on 11.3.0.5 but no iFix #045 is available on 11.3.0.6 due to the fact 11.3.0.6 released before this fix. Please open a PMR to create the same fix on 11.3.0.6.

Hope that helps.

Thanks,​

------------------------------
Tulasi Uppu

Original Message:
Sent: 10-26-2018 14:27
From: Glenn Cameron
Subject: Optim functions and NVARCHAR

​I'm new to Optim. We're on v11.3.0.6.

My first assignment with this tool is to come up with a test copy of a production Netezza database with masked and/or obfuscated PII fields.

I've figured out a lot of things and have had success but, the Optim functions don't work with NVARCHAR data types. I've had to have our DBA make copies of tables with NVARCHAR data types converted to VARCHAR. Then I can run all the Optim functions I need successfully. Finally the DBA copies the modified table VARCHAR data types back to NVARCHAR. I have the same requirement using SQL Server databases.

IBM hasn't been able to tell me whether NVARCHAR data types will be convertible in future versions but my feeling is that it isn't high on their list.

For clarification VARCHAR is ASCII and NVARCHAR is UTF-8.

Now my question; is that what everyone else is doing? If I submit a Request for Enhancement, is anyone else here interested in supporting that request?

------------------------------
Glenn Cameron
------------------------------

#InfoSphereOptim
#Optim