IBM C2090-552 Dumps

The Character or Numeric data must have a length of 256 bytes and be padded with blanks or binary zeros as needed.

The source column can only contain date or timestamp data.

The source column can contain date or timestamp data; character or numeric data may be used if a date format is applied to the AGE function.

The date format used in the Column Map must be entered in the format used by the database.

Column Maps cannot be used during Insert/Load, only during Convert.

No changes are made to the extract file, only to the rows as they are written to the database.

The original extract file remains unchanged, and a modified copy of the extract file is made with the Column Map specifications applied.

The original extract file is modified with the Column Map specifications.

Reduced maintenance costs because application and database maintenance and license fees are no longer paid for the old application and its database, but data remains accessible to the user community.

Decommissioned data is needed every day by end-users and Optim caches it in memory so access is faster then the production database.

Reporting from the application against the archived data can be cheaper using tiered storage.

Optim can store decommissioned data in a compressed format so it will take less storage then it did in production.

Applications must continue to use data in a seamless manner.

Archive Request, Access Definition, Optim Relationships, Column Maps

Archive Request and Access Definition only

Archive Request, Access Definition, and Table Map

Archive Request, Access Definition, Storage Profile, Report Request

Solaris, AIX, Ubuntu

Red Hat Enterprise Linux, HP-UX, AIX

SUSE Linux Enterprise, Solaris, Fedora

HP-UX, Ubuntu, Red Hat Enterprise Linux

Invoke the Column Map Editor.

Add additional functionality to the Table Maps that make up a Column Map.

Provide specifications needed to match or exclude columns or when data transformations are needed.

Validate that all data privacy rules established by a specific data governance policy are properly implemented.

Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays prompts and error dialogs during the process.

Schedules a job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays information dialogs during the process.

Runs the job named PERSONNEL, places the process report output in a file named PER.TXT, and displays information dialogs during the process.

Schedules the job named PERSONNEL, stores the extracted data in a file named PER.TXT, and displays prompts and error dialogs during the process.

An Insert process can always insert all the data successfully regardless of the presence of complex referential integrity (RI) cycles.

An Insert process allows for Update/Insert processing in one step; a Load process may not.

An Insert process will be faster than a Load process when inserting large volumes of data.

An Insert process allows you to use Column Maps to transform data; a Load process does not.

Retrieval Definition

Collection Name

Extract File

Restore Index

Only ODM/Optim Connect provides for access to individual archive files and collections of archive files.

ODM/Optim Connect will provide for the same levels of accessibility regardless of the underlying storage medium.

ODM/Optim Connect can implement row level security for archive data within the ODM/Optim Connect Workspace layer.

ODM/Optim Connect can be run stand-alone without Optim on the same machine.

Column Map names are a two part name

You can create a new Column Map from the Definitions submenu.

Columns with the same name and compatible data types are not automatically matched.

If a match is not found for a Destination or Source 2 column, the status is NOT USED or REQUIRED.

Right-click on the row and choose "Undo Row".

Right-click on the row and choose "Undo Change".

Right-click on the row and choose "Undo?.

Right-click on the row and choose "Undo All".

from the time Centera copies the file

from the time the Archive Process copies the file to Centera

from the time that the Archive Process copies the file to the local file system

from the time Centera copies the file from the local file system

Access to archive data performs just like a database.

ODM/Optim Connect must be used to access the archives.

Access using ODM/Optim Connect provides nearline access to archived data.

Archive data access should rarely be required.

Optim will not allow you to create duplicate relationships between tables.

Optim will view two relationships between tables as possible duplicates and ignore one.

Optim will view two relationships between tables as possible duplicates but will still use both if selected.

Optim allows duplicate relationships but will ignore them if they are in fact duplicate.

Optim will keep cycling until all relevant rows have been found.

Access Definition

Archive File

Browse Utility

Storage Profile

DB2 LUW, Oracle, Microsoft SQL Server, Microsoft Access

Sybase, Informix, Progress, DB2 LUW, MySQL, Microsoft SQL Server

Informix, Microsoft SQL Server, Sybase, DB2 LUW, Oracle

Microsoft Access, MySQL, Progress, DB2 LUW, Oracle, Sybase

By checking the nable Tracing?check box in the Optim Configuration applet in Control PanelBy checking the ?nable Tracing?check box in the Optim Configuration applet in Control Panel

By editing the pstserv.cfg or pstlocal.cfg file to enable tracing

By enabling tracing using the Optim Command Line Utility with the keyword TRACING=1

By using the idden?capabilities within the Windows GUI as explained by IBM SupportBy using the ?idden?capabilities within the Windows GUI as explained by IBM Support

They want to continue to use the CICS z/OS application to access the data.

Initially, their data was entered into their z/OS DB2 database. They have now decided to use Oracle on an AIX machine. They want to convert the DB2 packages to Oracle stored procedures.

They have data stored in both VSAM and DB2 on the z/OS platform and want to give up both their DB2 z/OS license and their hosted z/OS environment.

They want to store a copy of the application with the archives, in case they have to restore the data.