Content Management and Capture

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

1) throughput means how many document's can moved per hour? <-- This is going to be dependent on your environment, network speed, and the tuning you do for the sweep.

2) can I create multiple sweeps with same criteria and run at same time? <-- Yes, but you need to make sure they are using different filter expressions -- however this is not likely to improve the total speed with which your content is moved.

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area? <-- there could be, again network is going to come into play. Also, you want to consider what your long-term plan for the content and your FileNet installation is. If you plan, long-term to move to containers or a cloud installation, then moving to S3 or Azure blob is a good move. Also, if you have a need for retention settings and/or WORM storage, take that into account too.

If you email me directly (rhildebr@us.ibm.com), I'll send you a presentation on Move Sweep that includes performance tuning information.

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Michael,

So, a few thoughts.

1. Increase the number of pods of CPE that are running, the move content job can parallelize across them.
2. I would read the documentation carefully about sweeps Sweep policies - IBM Documentation
   1. There's some quirks to how workers and dispatching and threading and batching work for the different types of sweeps.
   2. You need to look at both the settings in the sweep itself as well as the threadand sweep settings at the domain or virtual server level.
   3. Decide if you really need it to delete from the source. Skipping delete can save a ton of time.Moving content with sweeps - IBM Documentation
3. At some point you're just going to hit the physical limit of your IS system. There are a lot of bottlenecks in the architecture of Image Services when it comes to processing this kind of work. We've developed work arounds for high-volume scenarios in the past to get this kind of work done faster by going around ISRA.

Best,

Eric

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Michael,

So, a few thoughts.

1. Increase the number of pods of CPE that are running, the move content job can parallelize across them.
2. I would read the documentation carefully about sweeps Sweep policies - IBM Documentation
   1. There's some quirks to how workers and dispatching and threading and batching work for the different types of sweeps.
   2. You need to look at both the settings in the sweep itself as well as the threadand sweep settings at the domain or virtual server level.
   3. Decide if you really need it to delete from the source. Skipping delete can save a ton of time.Moving content with sweeps - IBM Documentation
3. At some point you're just going to hit the physical limit of your IS system. There are a lot of bottlenecks in the architecture of Image Services when it comes to processing this kind of work. We've developed work arounds for high-volume scenarios in the past to get this kind of work done faster by going around ISRA.

Best,

Eric

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Michael,

So, a few thoughts.

1. Increase the number of pods of CPE that are running, the move content job can parallelize across them.
2. I would read the documentation carefully about sweeps Sweep policies - IBM Documentation
   1. There's some quirks to how workers and dispatching and threading and batching work for the different types of sweeps.
   2. You need to look at both the settings in the sweep itself as well as the threadand sweep settings at the domain or virtual server level.
   3. Decide if you really need it to delete from the source. Skipping delete can save a ton of time.Moving content with sweeps - IBM Documentation
3. At some point you're just going to hit the physical limit of your IS system. There are a lot of bottlenecks in the architecture of Image Services when it comes to processing this kind of work. We've developed work arounds for high-volume scenarios in the past to get this kind of work done faster by going around ISRA.

Best,

Eric

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

------------------------------
Venkat S

Original Message:
Sent: Tue April 16, 2024 10:37 AM
From: Jay Bowen
Subject: regarding Bulk content move sweep

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

------------------------------
Jay Bowen

Original Message:
Sent: Mon April 15, 2024 05:08 AM
From: Michael Pressler
Subject: regarding Bulk content move sweep

------------------------------
Michael Pressler

Original Message:
Sent: Tue February 06, 2024 08:43 AM
From: Gerold Krommer
Subject: regarding Bulk content move sweep

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

------------------------------
Gerold Krommer

Original Message:
Sent: Mon February 05, 2024 03:28 PM
From: Venkat S
Subject: regarding Bulk content move sweep

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

------------------------------
Venkat S

Original Message:
Sent: Mon February 05, 2024 11:23 AM
From: Gerold Krommer
Subject: regarding Bulk content move sweep

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

------------------------------
Gerold Krommer

Original Message:
Sent: Fri February 02, 2024 10:02 PM
From: Venkat S
Subject: regarding Bulk content move sweep

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

------------------------------
Venkat S
------------------------------

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

The FileNet Image Services Index and Workflo Database Contents manual is our friend (especially page 74). Assuming Oracle

SELECT COUNT(*) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

gives you the number of documents (1=text,3=mixed (unlikely you have one))

Number of pages:

SELECT SUM(NVL(F_PAGES,1) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

(This is from memory as I do not have an IS system in reach any more)

Hope this helps,

/Gerold

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

thanks Gerold/Jay for your prompt response.

I ran the queries as you advised and found that all cold documents are text based without any background template. if this is the case, Can I use simple java APIs(ex:Aspose) to convert text to pdf and store them to FileNet? please let me any thoughts on this.

1 - INX_TEXT_DOC - Text/Cold documents without background image

thanks,

Venkat

The FileNet Image Services Index and Workflo Database Contents manual is our friend (especially page 74). Assuming Oracle

SELECT COUNT(*) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

gives you the number of documents (1=text,3=mixed (unlikely you have one))

Number of pages:

SELECT SUM(NVL(F_PAGES,1) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

(This is from memory as I do not have an IS system in reach any more)

Hope this helps,

/Gerold

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

First, we are really deviating from the topic of the original posting.

Second, this all has been explained else where in this forum and even in this topic. COLD is not just text, it is P-Code(!) AND it is most likely (I would hope so, as one can see > 70:1 compression ratio) compressed. As I said you need the tools (ISRA or IDM Desktop) to get it uncompressed. THEN you can start worrying about layouting yout text. 

If it were that easy there wouldn't be the plethora of tools.

Kind regards,

/Gerold

thanks Gerold/Jay for your prompt response.

I ran the queries as you advised and found that all cold documents are text based without any background template. if this is the case, Can I use simple java APIs(ex:Aspose) to convert text to pdf and store them to FileNet? please let me any thoughts on this.

1 - INX_TEXT_DOC - Text/Cold documents without background image

thanks,

Venkat

The FileNet Image Services Index and Workflo Database Contents manual is our friend (especially page 74). Assuming Oracle

SELECT COUNT(*) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

gives you the number of documents (1=text,3=mixed (unlikely you have one))

Number of pages:

SELECT SUM(NVL(F_PAGES,1) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

(This is from memory as I do not have an IS system in reach any more)

Hope this helps,

/Gerold

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

For example, it is not entirely clear to me whether the MoveContent is more dependent on the settings in the Replication Subsystem or CFS Import Agendt Subsystem, or both, or not at all.




Via the context help menu I can see what the individual parameters mean, but there is no information about what influence the individual parameters have when you change them and with which settings you can possibly increase the throughput for the MoveContent.

I am of course aware that many factors play a role here. The FileNet system runs as a container in an AKS cluster in Azure, the IS system on a Windows VM also in Azure and the content vin P8 is written to an Azure blob storage. There are many possibilities as to why the MoveContent is so slow. But I want to make sure that everything is set up optimally in FileNet. 

I am grateful for any tips and help.

By the way, is there any chance to connect the IBM System Dashboard to a containernd FileNet System in an AKS-Cluster ? I tried but failed at the end.

 

Regards

Michael

First, we are really deviating from the topic of the original posting.

Second, this all has been explained else where in this forum and even in this topic. COLD is not just text, it is P-Code(!) AND it is most likely (I would hope so, as one can see > 70:1 compression ratio) compressed. As I said you need the tools (ISRA or IDM Desktop) to get it uncompressed. THEN you can start worrying about layouting yout text. 

If it were that easy there wouldn't be the plethora of tools.

Kind regards,

/Gerold

thanks Gerold/Jay for your prompt response.

I ran the queries as you advised and found that all cold documents are text based without any background template. if this is the case, Can I use simple java APIs(ex:Aspose) to convert text to pdf and store them to FileNet? please let me any thoughts on this.

1 - INX_TEXT_DOC - Text/Cold documents without background image

thanks,

Venkat

The FileNet Image Services Index and Workflo Database Contents manual is our friend (especially page 74). Assuming Oracle

SELECT COUNT(*) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

gives you the number of documents (1=text,3=mixed (unlikely you have one))

Number of pages:

SELECT SUM(NVL(F_PAGES,1) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

(This is from memory as I do not have an IS system in reach any more)

Hope this helps,

/Gerold

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

So there's a whole separate set of parameters for the Sweep Subsystem and then the specific job itself that will have the greatest impact.

For example, it is not entirely clear to me whether the MoveContent is more dependent on the settings in the Replication Subsystem or CFS Import Agendt Subsystem, or both, or not at all.




Via the context help menu I can see what the individual parameters mean, but there is no information about what influence the individual parameters have when you change them and with which settings you can possibly increase the throughput for the MoveContent.

I am of course aware that many factors play a role here. The FileNet system runs as a container in an AKS cluster in Azure, the IS system on a Windows VM also in Azure and the content vin P8 is written to an Azure blob storage. There are many possibilities as to why the MoveContent is so slow. But I want to make sure that everything is set up optimally in FileNet. 

I am grateful for any tips and help.

By the way, is there any chance to connect the IBM System Dashboard to a containernd FileNet System in an AKS-Cluster ? I tried but failed at the end.

 

Regards

Michael

First, we are really deviating from the topic of the original posting.

Second, this all has been explained else where in this forum and even in this topic. COLD is not just text, it is P-Code(!) AND it is most likely (I would hope so, as one can see > 70:1 compression ratio) compressed. As I said you need the tools (ISRA or IDM Desktop) to get it uncompressed. THEN you can start worrying about layouting yout text. 

If it were that easy there wouldn't be the plethora of tools.

Kind regards,

/Gerold

thanks Gerold/Jay for your prompt response.

I ran the queries as you advised and found that all cold documents are text based without any background template. if this is the case, Can I use simple java APIs(ex:Aspose) to convert text to pdf and store them to FileNet? please let me any thoughts on this.

1 - INX_TEXT_DOC - Text/Cold documents without background image

thanks,

Venkat

The FileNet Image Services Index and Workflo Database Contents manual is our friend (especially page 74). Assuming Oracle

SELECT COUNT(*) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

gives you the number of documents (1=text,3=mixed (unlikely you have one))

Number of pages:

SELECT SUM(NVL(F_PAGES,1) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

(This is from memory as I do not have an IS system in reach any more)

Hope this helps,

/Gerold

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat

For example, it is not entirely clear to me whether the MoveContent is more dependent on the settings in the Replication Subsystem or CFS Import Agendt Subsystem, or both, or not at all.




Via the context help menu I can see what the individual parameters mean, but there is no information about what influence the individual parameters have when you change them and with which settings you can possibly increase the throughput for the MoveContent.

I am of course aware that many factors play a role here. The FileNet system runs as a container in an AKS cluster in Azure, the IS system on a Windows VM also in Azure and the content vin P8 is written to an Azure blob storage. There are many possibilities as to why the MoveContent is so slow. But I want to make sure that everything is set up optimally in FileNet. 

I am grateful for any tips and help.

By the way, is there any chance to connect the IBM System Dashboard to a containernd FileNet System in an AKS-Cluster ? I tried but failed at the end.

 

Regards

Michael

First, we are really deviating from the topic of the original posting.

Second, this all has been explained else where in this forum and even in this topic. COLD is not just text, it is P-Code(!) AND it is most likely (I would hope so, as one can see > 70:1 compression ratio) compressed. As I said you need the tools (ISRA or IDM Desktop) to get it uncompressed. THEN you can start worrying about layouting yout text. 

If it were that easy there wouldn't be the plethora of tools.

Kind regards,

/Gerold

thanks Gerold/Jay for your prompt response.

I ran the queries as you advised and found that all cold documents are text based without any background template. if this is the case, Can I use simple java APIs(ex:Aspose) to convert text to pdf and store them to FileNet? please let me any thoughts on this.

1 - INX_TEXT_DOC - Text/Cold documents without background image

thanks,

Venkat

The FileNet Image Services Index and Workflo Database Contents manual is our friend (especially page 74). Assuming Oracle

SELECT COUNT(*) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

gives you the number of documents (1=text,3=mixed (unlikely you have one))

Number of pages:

SELECT SUM(NVL(F_PAGES,1) FROM F_SW.DOCTABA WHERE F_DOCTYPE =1 OR F_DOCTYPE=3

(This is from memory as I do not have an IS system in reach any more)

Hope this helps,

/Gerold

may I know the database query to run on IS doctaba identify cold documents and their count? basic I need to know the difference b/w normal documents and COLD documents by looking at database enrtries.

much appreciated if someone can answer my query.

thanks,

Venkat

Hi,

I have commented on the same question somewhere else in this forum. IS COLD is formatted in P-Code (of which I have VERY old documentation), but if it is compressed you absolutely MUST use one of the mentioned tools to get it uncompressed.

Only then use one of the very valid approaches mentioned previously or write your own layout engine. If you never used anything else than FileNet COLD only a limited subset of P-Code is used (which makes such an approach feasible, I would NEVER want to write a generic layout engine regardless of syntax).

There are/were other tools out, that would e.g. produce mixed documents (COLD and image mixed on different pages) and then it gets comples.

Hope this helps,

/Gerold

Hi Jay,

thanks so much for your response.

I am talking about COLD documents which are template based, I believe they are nothing but overlays. 

best regards,

Venkat

Hi Venkat, which COLD are we talking about compressed text or image overlay? If it is compressed COLD there is a jar part of IBM ISRA APIs for decompression for best speed. For overlays I have found the best approach, highest fidelity is to reach back into the time machine and create a .net winform app and embed the IDM viewer. Use the IDM API's to fetch and view the document in viewer, the viewer has an API method for print and set default printer to PDF ahead of time then capture the file. I know- there could be millions of files so you create 10 nodes or more that just virtual print 24/7 from a concurrent queue or db. Your other option is IDM API to get text, get rows, get columns and manage the layout which you do programmatically. Much faster but requires you to do the layout.  Cost is usually a fraction of other approaches it's just the calendar time waiting for the process to finish. 

I'd be interested in hearing from vendors that have COLD tools, how they do it and cost brackets.  

Hi Jay/others

could you please provide solution to convert COLD documents to either TIF or PDF.

Thanks and regards,

Venkat

Hi, I have migrated a number of IS systems typically these were export > convert PDF > import with two traditional migrations IS>P8 via CFS federation. For raw speed reading the MSAR file directly you can process a surface in an hour hands down fastest method of extraction.  IDM APIs are much slower but you can have multiple nodes extracting and converting pages, allows in line transformations to PDF or merge TIFF, COLD conversions things you can't do with a CFS approach. WAL is faster for sure but more complicated and sensitive to deployment environment. Now getting to IS to P8 federation the first thing you can do to significantly improve performance is increase your page cache by adding a disk or expanding your current volume(s), then increase the TTL for those objects. If you are not scanning into IS change your allocation % of use so that retrieval cache is your largest pool.  My own observations the SAN or disk used for MSAR also has a performance impact obviously there is a lot of I/O going to happen so organize your migrations by surface. Batch content move is great but I have had some issues where a convenient approach with a move sweep revealed some weaknesses in customers environment and then fixing caused a mountain of work. Instead I used the CPE APIs, organized my requests by objects on each surface and perform the move.  Takes more prep time but you are notching progress one surface at a time, very manageable as well. Optionally you can prefetch these IDs into cache.  Now it doesn't necessarily make sense to me why disk cache is faster than disk MSAR other than nothing is faster than IS page cache.  When using the CPE contentmove API approach I have tried batch updates, multi threaded calls, large batches, small batches to see what I could squeeze out of CPE/IS.  AS others mentioned I ended up with deadlocks and all sorts of issues when I increased the thread pressure using multiple API calls.  In the end I am using batch update with 10 docs/per second per API call so 600 doc objects/second various page counts.  Other values you can do for tuning- 

WAS - orb.thread.pool 125, WAS JDBC > 100 connections max, ACCE GCD Abandoned cleanup interval 1036800, Temp file lifetime 1036800, content queue max worker 100, site settings level IS object where ISuser/pwd/domain is set I increased timeout seconds to 50000. 

Hi,

depending on the requirements we have used different strategies including Move Content and export/import.

Assuming - for simplicity - 100 docs/sec it will take you net 115 days to move (if my math is correct), given normal maintenance interruptions it will be half a year wall clock time. If you have nothing to convert, a real plain move of content and the migration is not time critical (you have to pay maintenance for the two parallel systems) then you a are good to go.

If any of the assumptions above does not hold, consider exporting and importing. Using 4 bare metal Linux servers with ample memory and cpu, two additional virtualized servers, dedicated network and dedicated carefully crafted and tuned import clients we achieved 600 docs/sec, but those were not really useable as the TSM (sorry, Spectrum Protect) server could not keep up with that (the staging area filled up and we had to pause the import ) and we achieved a real (net) import rate of 250 docs/sec. This was also for a billion documents from a host that were prepared beforehand and staged on disk.

Needless to say the system wasn't useable during import (ran next to 100% CPU) but didn't have to as the customer switched to P8 after import...

Not a lot of ECM system can do as fast and stable as P8.

Hope this helps,

/Gerold

Hi Gerold,

thanks so much for your response.

so you have have followed the same approach i.e. CFSIS for metadata migration and content move sweep for content migration right?

based on your experience, do you recommend the above said approach or some other approach? we are planning to migrate around One billion equivalent to 1000 million documents.

in my case, we will migrate documents first and will ask users to use p8 once migration is done.

Hi,

we did many of those migrations  and in addition to what Ruth said:

If your IS system still contains documents with multiple pages stored as single-page TIFFs then you will get one document with many content elements and the user experience with those is probably not what they expect, although Daeja has improved over time.

We migrated IS systems with several hundreds of millions of documents from IS to P8 and refrained from much tuning as it always had collateral damage as locking errors or degraded performance for users (the migration was done on productive systems as migrations over weekends or the like were impossible).

Having said that - on a very rough ballpark figure on a reasonably sized system  - you should be able to achieve 60 documents/second as an order of magnitude (what that is in docs/hour I leave to your math). We found document size to be more of a limiting factor than amount.

Do not forget you might have to stop migration in backup windows.

It is not uncommon for larger migrations to run for months and it is a matter of scrutinizing, bookkeeping and following up on inevitable errors that will appear.

With one customer we used IBM Cloud Object Storage as the target storage (fixed content device as HW retention was required) and didn't find this to be a limiting factor of any kind, but of course there is the staging area...

Hope that helps,

Gerold

I have federated metadata of documents in Image services to FileNet P8(5.5.9) and planning to move content(from FCD area to local FileNet storage area) of the federated documents using Bulk content move sweep so i need help regarding below:

1) throughput means how many document's can moved per hour?

2) can I create multiple sweeps with same criteria and run at same time?

3) will there be a difference(in terms of throughput & performance) if I use cloud storage area(using S3 or Azure blob) instead of local FileNet storage area?

much appreciated if someone can respond on this quickly.

thanks in advance

Venkat