Informix Consultant

  • Full Time
  • Warsaw

Website Collabera

Job Description

  • Performing an IDS Installation Overhaul including:
  • Analysis of Informix database engine operation
  • Validation of supported products for version, patchwork level and completeness,
  • Analysis of IDS database engine log entries
  • Tables with the highest number of pages allocated
  • Tables with the highest number of free pages
  • Tables with the highest number of extents
  • Tables with the highest value of fields of the SERIAL type
  • Number of backup objects in ixbar.<servernum> file
  • Analysis of the burden and use of resources
  • Processor load
  • Drive Load
  • Loading the buffer pool
  • Locks on data records
  • SQL processing
  • Analysis of the configuration of the operating system in terms of the requirements of the
  • Informix database engine
  • Analysis of application processing
  • Database load generated by SQL queries
  • SQL query types by number of readings from buffers
  • Types of SQL queries by number of readings from disks
  • Types of SQL queries by time of execution
  • Analysis of the creation and use of provisional tables
  • Drawing of SQL queries, including analysis of about 20 selected calls of the most burdensome queries in 4GL, Java and Business Object applications
  • Analysis of the optimal division of the production environment into IDS instances – recommendation for the current hardware infrastructure and the best approach to implementation in the new hardware infrastructure – in terms of the best scaling of the database engine (vertical/horizontal)
  • Analysis of the creation and use of non-productive environments
  • Analysis of the use of processing in memory (Informix Warehouse Accelerator functionality) and recommendations
  • Recommendations and final conclusions
    the completion of the IDS Installation Overview will be confirmed by a report containing the scope of work performed as well as recommendations and final conclusions
Location City:
Location Country:
Upload your CV/resume or any other relevant file. Max. file size: 512 MB.