​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Hello Phil,

Currently, doesn't support Azure DB's. But IBM has these in the pipeline but not sure when it will be supported.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna
------------------------------

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Sorry missed asking you, what are the type of DB's? are they Oracle, SQL Server etc., relational Db's or Cloud DB's which is Microsoft Azure Cloud SQL Database. 

If it is Oracle, SQL Server etc., DB's Optim can access them as usual but if it is Cloud DB's then support needs to be added for it and they are part of future requirements.

Thanks,
Vishwas


------------------------------
Vishwas Balakrishna
------------------------------

Original Message:
Sent: 07-10-2018 17:14
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

Currently, doesn't support Azure DB's. But IBM has these in the pipeline but not sure when it will be supported.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Hi,

Azure database (which is basically SQL Server on the Cloud) is one of the Cloud data sources Optim is looking at for priority support.  However, we don't have it committed in plan at this time.  (The plan goes out to October 2018).

Many customers have been successful using open connectivity (ODBC or JDBC driver support) combined with DB2 or Oracle federation, to access many data sources.  It's likely that a Microsoft DB (Azure DB) would support ODBC (a Microsoft initiated standard) well.  So it's likely that Optim can support this as what we call an "extended data source". 

Here is more about Optim extended data source support:

Extended Data Sources

 

• Optim enables a standard JDBC/ODBC or federated connection to relational or data type specific sources.  This enables access to data sources and the ability to leverage Optim capabilities.
• Extended data sources have not been tested or otherwise validated by Optim QA.
• While JDBC / ODBC provide an industry standard, specific implementations of these drivers may vary. Some limitations may exist.
• Optim functionality or behavior may vary based on the limitations of the driver.
• Optim's several different Solutions tend to "stress" different features of DBMS connectivity.  For example, an Archive user may stress Optim (and therefore DBMS) Delete while a Test Data Management user might not use Delete much or at all.  As another example, TDM tends to stress Insert operations, while an Archiving/Data Growth/Application Retirement customer may not use Optim's (and the ODBC/JDBC driver's) DBMS Insert at all.  Therefore, it is possible that the same driver that can successfully be used by one Optim Solution may fail to support a different Optim Solution.
• Optim Support can assist in connecting, but is not able to guarantee connectivity or any specific Optim functionality.
  • Optim Support is very unlikely to have the extended data source and the ODBC / JDBC driver installed for problem recreation, so customer participation in problem identification and resolution is very likely to be greater than with a supported data source.
  • Support for Optim use of the ODBC or JDBC driver is dependent on the software vendor that supplies the driver.  It is typically not entirely under IBM control.  The customer may need to interact with the vendor providing the ODBC or JDBC driver to resolve a problem.
• The greater Optim team (including Optim Technical Sales, IBM and lab services, Optim Development, Optim Support, Optim partners, and certain customers willing to be references) may possibly have experience, positive or negative, with connecting to a given data source using one or more ODBC or JDBC connectors.

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA
------------------------------

Original Message:
Sent: 07-10-2018 17:18
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Sorry missed asking you, what are the type of DB's? are they Oracle, SQL Server etc., relational Db's or Cloud DB's which is Microsoft Azure Cloud SQL Database.

If it is Oracle, SQL Server etc., DB's Optim can access them as usual but if it is Cloud DB's then support needs to be added for it and they are part of future requirements.

Thanks,
Vishwas


------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 17:14
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

Currently, doesn't support Azure DB's. But IBM has these in the pipeline but not sure when it will be supported.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

I had the network guys working on this and trying to get conntected using Extended Data Sources.  He is getting an error stating the 'Reference to database and/or server name in 'master.sys.databases' is not supported in this version of SQL Server.  Who can I get him in contact with to work through the issue?

Thanks,

Phil

------------------------------
Phil Neff
------------------------------

Original Message:
Sent: 07-11-2018 01:28
From: Peter Costigan
Subject: Optim connectivity to Azure PaaS database

Hi,

Azure database (which is basically SQL Server on the Cloud) is one of the Cloud data sources Optim is looking at for priority support.  However, we don't have it committed in plan at this time.  (The plan goes out to October 2018).

Many customers have been successful using open connectivity (ODBC or JDBC driver support) combined with DB2 or Oracle federation, to access many data sources.  It's likely that a Microsoft DB (Azure DB) would support ODBC (a Microsoft initiated standard) well.  So it's likely that Optim can support this as what we call an "extended data source".

Here is more about Optim extended data source support:

Extended Data Sources

 

• Optim enables a standard JDBC/ODBC or federated connection to relational or data type specific sources.  This enables access to data sources and the ability to leverage Optim capabilities.
• Extended data sources have not been tested or otherwise validated by Optim QA.
• While JDBC / ODBC provide an industry standard, specific implementations of these drivers may vary. Some limitations may exist.
• Optim functionality or behavior may vary based on the limitations of the driver.
• Optim's several different Solutions tend to "stress" different features of DBMS connectivity.  For example, an Archive user may stress Optim (and therefore DBMS) Delete while a Test Data Management user might not use Delete much or at all.  As another example, TDM tends to stress Insert operations, while an Archiving/Data Growth/Application Retirement customer may not use Optim's (and the ODBC/JDBC driver's) DBMS Insert at all.  Therefore, it is possible that the same driver that can successfully be used by one Optim Solution may fail to support a different Optim Solution.
• Optim Support can assist in connecting, but is not able to guarantee connectivity or any specific Optim functionality.
  • Optim Support is very unlikely to have the extended data source and the ODBC / JDBC driver installed for problem recreation, so customer participation in problem identification and resolution is very likely to be greater than with a supported data source.
  • Support for Optim use of the ODBC or JDBC driver is dependent on the software vendor that supplies the driver.  It is typically not entirely under IBM control.  The customer may need to interact with the vendor providing the ODBC or JDBC driver to resolve a problem.
• The greater Optim team (including Optim Technical Sales, IBM and lab services, Optim Development, Optim Support, Optim partners, and certain customers willing to be references) may possibly have experience, positive or negative, with connecting to a given data source using one or more ODBC or JDBC connectors.

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA

Original Message:
Sent: 07-10-2018 17:18
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Sorry missed asking you, what are the type of DB's? are they Oracle, SQL Server etc., relational Db's or Cloud DB's which is Microsoft Azure Cloud SQL Database.

If it is Oracle, SQL Server etc., DB's Optim can access them as usual but if it is Cloud DB's then support needs to be added for it and they are part of future requirements.

Thanks,
Vishwas


------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 17:14
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

Currently, doesn't support Azure DB's. But IBM has these in the pipeline but not sure when it will be supported.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna
------------------------------

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff
------------------------------

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna
------------------------------

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Hi Phill,

Optim upcoming FixPack 11.3.0.7 is enabled to support this.

However if you would like to proceed with a workaround, here is the step:
Identify the right folder and file RT/BIN/SP/MSS*/CSSCMSPC.SQL
Update the procedure CSSGETSIGNATURE like this
Change  "master.sys.databases d  WHERE d.name = 'msdb' " to "sys.databases d     WHERE d.name = 'master'"

Thanks,
Tulasi

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

Original Message:
Sent: 07-20-2018 10:58
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

​When is this Fix Pack scheduled to be released?

Thanks,

Phil

------------------------------
Phil Neff
------------------------------

Original Message:
Sent: 07-24-2018 02:45
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

Hi Phill,

Optim upcoming FixPack 11.3.0.7 is enabled to support this.

However if you would like to proceed with a workaround, here is the step:
Identify the right folder and file RT/BIN/SP/MSS*/CSSCMSPC.SQL
Update the procedure CSSGETSIGNATURE like this
Change  "master.sys.databases d  WHERE d.name = 'msdb' " to "sys.databases d     WHERE d.name = 'master'"

Thanks,
Tulasi

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

Original Message:
Sent: 07-20-2018 10:58
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

I will defer to Optim PLM (Peter Costigan) to answer release date.

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

Original Message:
Sent: 07-25-2018 08:40
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​When is this Fix Pack scheduled to be released?

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-24-2018 02:45
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

Hi Phill,

Optim upcoming FixPack 11.3.0.7 is enabled to support this.

However if you would like to proceed with a workaround, here is the step:
Identify the right folder and file RT/BIN/SP/MSS*/CSSCMSPC.SQL
Update the procedure CSSGETSIGNATURE like this
Change  "master.sys.databases d  WHERE d.name = 'msdb' " to "sys.databases d     WHERE d.name = 'master'"

Thanks,
Tulasi

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

Original Message:
Sent: 07-20-2018 10:58
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Hi,

Sorry to have missed this, somehow, earlier. 

Anyway: the current plan is for Optim Distributed 11.3 Fixpack 7 to be available in Q4 2018.  Please remember plans are subject to change.  The internal plan date is end of October, but those dates are often optimistic.

Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA
------------------------------

Original Message:
Sent: 07-26-2018 05:12
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

I will defer to Optim PLM (Peter Costigan) to answer release date.

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

Original Message:
Sent: 07-25-2018 08:40
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​When is this Fix Pack scheduled to be released?

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-24-2018 02:45
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

Hi Phill,

Optim upcoming FixPack 11.3.0.7 is enabled to support this.

However if you would like to proceed with a workaround, here is the step:
Identify the right folder and file RT/BIN/SP/MSS*/CSSCMSPC.SQL
Update the procedure CSSGETSIGNATURE like this
Change  "master.sys.databases d  WHERE d.name = 'msdb' " to "sys.databases d     WHERE d.name = 'master'"

Thanks,
Tulasi

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

Original Message:
Sent: 07-20-2018 10:58
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Oops, and I forgot that the context was Azure DB support, which is a STRETCH GOAL, not a commitment, in fixpack 7.  Given certain other stretch goals are aggressively being moved in by Development, I think the chances are actually low to be able to get Azure support into Fixpack 7.

Don't get me wrong, it's very high priority, but there are other very high priority items crowding Azure DB support out.

Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA
------------------------------

Original Message:
Sent: 08-16-2018 18:04
From: Peter Costigan
Subject: Optim connectivity to Azure PaaS database

Hi,

Sorry to have missed this, somehow, earlier.

Anyway: the current plan is for Optim Distributed 11.3 Fixpack 7 to be available in Q4 2018.  Please remember plans are subject to change.  The internal plan date is end of October, but those dates are often optimistic.

Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA

Original Message:
Sent: 07-26-2018 05:12
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

I will defer to Optim PLM (Peter Costigan) to answer release date.

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

Original Message:
Sent: 07-25-2018 08:40
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​When is this Fix Pack scheduled to be released?

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-24-2018 02:45
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

Hi Phill,

Optim upcoming FixPack 11.3.0.7 is enabled to support this.

However if you would like to proceed with a workaround, here is the step:
Identify the right folder and file RT/BIN/SP/MSS*/CSSCMSPC.SQL
Update the procedure CSSGETSIGNATURE like this
Change  "master.sys.databases d  WHERE d.name = 'msdb' " to "sys.databases d     WHERE d.name = 'master'"

Thanks,
Tulasi

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

Original Message:
Sent: 07-20-2018 10:58
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Peter,

This is a VERY high priority for us.  We are rapidly moving our databases to Azure PaaS DB.  If Optim does not provide a solution we may need to look for another tool.

Thanks,

Phil

------------------------------
Phil Neff
------------------------------

Original Message:
Sent: 08-16-2018 18:07
From: Peter Costigan
Subject: Optim connectivity to Azure PaaS database

Oops, and I forgot that the context was Azure DB support, which is a STRETCH GOAL, not a commitment, in fixpack 7.  Given certain other stretch goals are aggressively being moved in by Development, I think the chances are actually low to be able to get Azure support into Fixpack 7.

Don't get me wrong, it's very high priority, but there are other very high priority items crowding Azure DB support out.

Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA

Original Message:
Sent: 08-16-2018 18:04
From: Peter Costigan
Subject: Optim connectivity to Azure PaaS database

Hi,

Sorry to have missed this, somehow, earlier.

Anyway: the current plan is for Optim Distributed 11.3 Fixpack 7 to be available in Q4 2018.  Please remember plans are subject to change.  The internal plan date is end of October, but those dates are often optimistic.

Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA

Original Message:
Sent: 07-26-2018 05:12
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

I will defer to Optim PLM (Peter Costigan) to answer release date.

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

Original Message:
Sent: 07-25-2018 08:40
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​When is this Fix Pack scheduled to be released?

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-24-2018 02:45
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

Hi Phill,

Optim upcoming FixPack 11.3.0.7 is enabled to support this.

However if you would like to proceed with a workaround, here is the step:
Identify the right folder and file RT/BIN/SP/MSS*/CSSCMSPC.SQL
Update the procedure CSSGETSIGNATURE like this
Change  "master.sys.databases d  WHERE d.name = 'msdb' " to "sys.databases d     WHERE d.name = 'master'"

Thanks,
Tulasi

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

Original Message:
Sent: 07-20-2018 10:58
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim

Hi Phil,

Thanks very much for the important and useful requirements feedback for Optim.

Can you please share your company name?  I'd like to connect the feedback to a  specific IBM client.  If you'd prefer to keep it out of the group discussion you could email it to me: costigan@us.ibm.com

Thank you,
Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA
------------------------------

Original Message:
Sent: 08-17-2018 08:19
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

Peter,

This is a VERY high priority for us.  We are rapidly moving our databases to Azure PaaS DB.  If Optim does not provide a solution we may need to look for another tool.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 08-16-2018 18:07
From: Peter Costigan
Subject: Optim connectivity to Azure PaaS database

Oops, and I forgot that the context was Azure DB support, which is a STRETCH GOAL, not a commitment, in fixpack 7.  Given certain other stretch goals are aggressively being moved in by Development, I think the chances are actually low to be able to get Azure support into Fixpack 7.

Don't get me wrong, it's very high priority, but there are other very high priority items crowding Azure DB support out.

Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA

Original Message:
Sent: 08-16-2018 18:04
From: Peter Costigan
Subject: Optim connectivity to Azure PaaS database

Hi,

Sorry to have missed this, somehow, earlier.

Anyway: the current plan is for Optim Distributed 11.3 Fixpack 7 to be available in Q4 2018.  Please remember plans are subject to change.  The internal plan date is end of October, but those dates are often optimistic.

Peter

------------------------------
Peter Costigan
Offering Manager, Optim Solutions
IBM
San Jose CA

Original Message:
Sent: 07-26-2018 05:12
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

I will defer to Optim PLM (Peter Costigan) to answer release date.

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

Original Message:
Sent: 07-25-2018 08:40
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​When is this Fix Pack scheduled to be released?

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-24-2018 02:45
From: Tulasi Uppu
Subject: Optim connectivity to Azure PaaS database

Hi Phill,

Optim upcoming FixPack 11.3.0.7 is enabled to support this.

However if you would like to proceed with a workaround, here is the step:
Identify the right folder and file RT/BIN/SP/MSS*/CSSCMSPC.SQL
Update the procedure CSSGETSIGNATURE like this
Change  "master.sys.databases d  WHERE d.name = 'msdb' " to "sys.databases d     WHERE d.name = 'master'"

Thanks,
Tulasi

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

Original Message:
Sent: 07-20-2018 10:58
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

I looked at the PR0CNFG file and I see below error,

ErrMsg1: [Microsoft][SQL Server Native Client 11.0][SQL Server]Reference to database and/or
name in 'master.sys.databases' is not supported in this version of SQL Server.

By looking at the above error, I feel that Optim doesn't support this version of SQL Server database.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-20-2018 10:27
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​Vishwas,

I am attaching the requested PR0CNFG files.  Let me know if you need me to do anything else.

Thanks,

Phil

------------------------------
Phil Neff

Original Message:
Sent: 07-17-2018 09:02
From: Vishwas Balakrishna
Subject: Optim connectivity to Azure PaaS database

Hello Phil,

You might have to raise the PMR to IBM support and also I can review the PR0CNFG trace files in the meantime if you can attach them to the discussion.

Thanks,
Vishwas

------------------------------
Vishwas Balakrishna

Original Message:
Sent: 07-10-2018 16:25
From: Phil Neff
Subject: Optim connectivity to Azure PaaS database

​ We are in need to design the archive/purge process for tables on Azure PaaS. How can we do this using Optim?  How can we connect with the Optim for these dbs.

Thanks,

Phil


------------------------------
Phil Neff
------------------------------

#InfoSphereOptim
#Optim