1 / 17

Informer 4 Maintenance: Upgrades, Logs & Database Maintenance

Join Sarah Rodger, Informer Support Specialist, to learn about Informer system maintenance tasks including upgrades, log files, and database maintenance. Discover best practices for ensuring a smooth and efficient Informer experience.

plunkett
Download Presentation

Informer 4 Maintenance: Upgrades, Logs & Database Maintenance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. February 11-13, 2019 Raleigh, NC

  2. Informer 4 Maintenance Presenter: Sarah Rodger Informer Support Specialist

  3. Overview • The Informer System • Maintenance Tasks • Upgrades • Log Files • Derby Database Tables • Routine Database Backups & Package Backups • Scheduled Restarts

  4. Informer is a Three-Tier System!

  5. Upgrading Informer • Current Version: 4.7.3 4.7.4 (as of next week!) • Why Bother Upgrading? • Bug fixes & New features: Check the Release Notes! • Having the latest version expedites support resolution • Utilities are not supported prior to version 4.5 • Package exports to Informer 5 are not supported prior to version 4.5

  6. Upgrading Informer • Download the most recent .war upgrade file • Client Portal (you must be the Technical Contact for your organization) • Support Ticket • Place inside the ./webapp folder on the Informer server • Restart Informer • … wait … • Done! Note: Once you successfully upgrade, you can delete the .war files for the older versions of Informerto free up space. *** See Installation/Upgrades Upgrades to review prereqsfor older versions***

  7. Log Maintenance

  8. Log Maintenance / Access • Reset the Log Settings • Admin -> Log Settings -> Restore Default • Set up Rolling Logs • Affects openinformer.log, not servicelog.txt • If Windows, turn off servicelog.txt

  9. Log Settings • Returns the basics of what Informer is doing log4j.logger.com.entrinsik.informer=info • Returns what statements are sent to the database (U2) log4j.logger.com.entrinsik.informer.uoj.STATEMENTS=info • Returns what statements are sent to the database (SQL) log4j.logger.com.entrinsik.informer.sql.query=DEBUG • Returns what comes back from the database (U2) log4j.logger.com.entrinsik.informer.uoj=DEBUG • Returns what comes back from the database (SQL) log4j.logger.com.entrinsik.informer.sql=TRACE

  10. Database Maintenance • Historical tables grow over time • LAUNCHAUDIT • JOBHISTORY (Scheduler History) • DATAARCHIVE • Most users don’t need content from 20XX and earlier. You determine how far back you want to purge • Can be cleaned up via derby command line to reclaim space

  11. Schedule Maintenance • Spread out your scheduled jobs • Ideally have no more than one job scheduled each minute if possible • Many schedules launched at the same time can cause bottlenecks or break the scheduler thread

  12. Backups ***Make frequent backups in case of catastrophic failure *** • Informer database is located in the ./db folder • Opt 1: Stop Informer then copy just like any folder • Opt 2: Use Derby commands to freeze updates on an active system while copying. • Other options are: virtual system snapshot – but it can be corrupted

  13. Packages as Backups • Useful for specific object backups • Reports • Datasources • Mappings • Less useful for full-system backups. • Be wary of duplication! Informer 4 will let you import what you already have. Best recovery: restore from a backup.

  14. Restarts • When it fixes things: • Releases cached items, on both the application and the server • Restarts a potentially frozen Scheduler • When you must restart: • Any time you edit the .properties files • If you change memory allocation or other java settings • Best practices: • Can be scheduled during confirmed downtimes, like early morning on weekends • Note: this is a Service restart, not a Server restart

  15. Useful Help Center Articles • Upgrade Informer to the Latest Version • Best practices for managing disk space with Informer 4 • How to backup and restore Informer 4.x • Useful Log Settings • Can I delete the servicelog.txt file? What exactly is this file? • Setting Up Rolling Logs • How to update a license • How to tune your scheduler

  16. Thank you! Any questions?

  17. February 11-13, 2019 Raleigh, NC

More Related