​Hello All,

If we have 10 schemas and I am archiving all 10 schemas by creating 10 different AD/AR's (live Archival). Each of this is tagged to a different collection i.e. I have 10 different collections going by schema name. For data retrieval, do I need to have 10 data sources created or can I have 1 data source created for all 10 collections?

Thank you

------------------------------
Optim Learner
------------------------------

#InfoSphereOptim
#Optim

Hi,

Each collection represent one datasource, i.e. if you want to have 1 datasource only you should archive in 1 collection only.

Regards,
Fritz

------------------------------
FRIEDRICH PFNEISL
Optim SME
Austria
------------------------------

​Thank you Friedrich. I was wondering if anyone was able to create just 1 datasource even though there are multiple collections.

------------------------------
Optim Learner
------------------------------

Original Message:
Sent: Wed February 19, 2020 02:55 AM
From: FRIEDRICH PFNEISL
Subject: DataSource/Collection

Hi,

Each collection represent one datasource, i.e. if you want to have 1 datasource only you should archive in 1 collection only.

Regards,
Fritz

------------------------------
FRIEDRICH PFNEISL
Optim SME
Austria
------------------------------

I don't believe that is possible with Optim Connect...and even if it were possible, I'd advise against it. We've found some shortcomings with Optim's memory management when attempting to run queries on too much underlying data inside an archive collection. You need to keep in mind that you are not getting the benefit of a DBMS engine to process your SQL against an archive collection. Instead, all this data is unloaded into memory and temporary space and it's easy to overwhelm the process, so smaller and smarter is definitely better. 




------------------------------
Keith Tidball
Progressive Insurance
------------------------------

Original Message:
Sent: Thu February 27, 2020 02:22 PM
From: Optim Learner
Subject: DataSource/Collection

​Thank you Friedrich. I was wondering if anyone was able to create just 1 datasource even though there are multiple collections.

------------------------------
Optim Learner
------------------------------


Original Message:
Sent: Wed February 19, 2020 02:55 AM
From: FRIEDRICH PFNEISL
Subject: DataSource/Collection

Hi,

Each collection represent one datasource, i.e. if you want to have 1 datasource only you should archive in 1 collection only.

Regards,
Fritz

------------------------------
FRIEDRICH PFNEISL
Optim SME
Austria

Thank you Keith​

------------------------------
Optim Learner
------------------------------

Original Message:
Sent: Fri February 28, 2020 10:03 AM
From: Keith Tidball
Subject: DataSource/Collection

I don't believe that is possible with Optim Connect...and even if it were possible, I'd advise against it. We've found some shortcomings with Optim's memory management when attempting to run queries on too much underlying data inside an archive collection. You need to keep in mind that you are not getting the benefit of a DBMS engine to process your SQL against an archive collection. Instead, all this data is unloaded into memory and temporary space and it's easy to overwhelm the process, so smaller and smarter is definitely better. 




------------------------------
Keith Tidball
Progressive Insurance
------------------------------


Original Message:
Sent: Thu February 27, 2020 02:22 PM
From: Optim Learner
Subject: DataSource/Collection

​Thank you Friedrich. I was wondering if anyone was able to create just 1 datasource even though there are multiple collections.

------------------------------
Optim Learner


Original Message:
Sent: Wed February 19, 2020 02:55 AM
From: FRIEDRICH PFNEISL
Subject: DataSource/Collection

Hi,

Each collection represent one datasource, i.e. if you want to have 1 datasource only you should archive in 1 collection only.

Regards,
Fritz

------------------------------
FRIEDRICH PFNEISL
Optim SME
Austria