BUG FIX ARCHIVE

Download link 

https://mats.datavard.com/downloader.php?ticketid=03780d744b947b8a3d74d992a6594112

Description: OutBoard DataTiering SP25 FIX-012 Get correct cluster table

Password: Datavard1

Transports requests

ISSUE DESCRIPTION

Load activation and report /DVD/NLS_W2_CHECK_DSO dumps for object archived in the Sybase IQ storage.

ERROR DESCRIPTION

If a storage for the object was updated to Sybase IQ, there could be more cluster table names for this object in the /DVD/NL2_OBJSTOR table. During the load activation or execution of the report /DVD/NLS_W2_CHECK_DSO a single cluster table name is selected for this object, bud it could be the one, which does not exist anymore. Following select statement on this table then dumps.

SOLUTION

Select correct cluster table name based on the archiving request SID.