Coforge Technical Architect Interview Questions and Answers for Experienced

Migrating DB2 to other RDBMS involves selecting target RDBMS, exporting data, converting schema, and importing data.

• Select the target RDBMS and ensure compatibility with DB2 data types and features

• Export data from DB2 using tools like IBM Data Movement Tool or IBM InfoSphere Data Replication

• Convert schema to target RDBMS using tools like IBM SQL Compatibility Tool or manual scripting

• Import data into target RDBMS using ...read more

There are various ways to convert files depending on the file type and desired output format.

• Use online file converters such as Zamzar or CloudConvert

• Use software specific to the file type such as Adobe Acrobat for PDFs

• Use command line tools such as ffmpeg for media files

• Use programming languages such as Python to write custom conversion scripts

To access security on CICS screen on distributed system, use CICS Transaction Server Security.

• Use CICS Transaction Server Security to control access to CICS resources.

• Define security policies and profiles to control access to CICS resources.

• Use the CICS Security API to check security status and perform security-related tasks.

• Examples of CICS security features include RACF, ACF2, and Top Secret.

• Ensure that all users hav...read more

Migrating Mainframe security to Distributed system requires careful planning and execution.

• Identify the security requirements of the Mainframe system

• Evaluate the security features of the Distributed system

• Develop a migration plan that addresses any gaps in security features

• Test the security of the Distributed system thoroughly before deployment

• Train users on the new security features and best practices