Bookkeeping

• LHCb Bookkeeping database administration
  • Login to the database
  • Ticketing, contacts for IT-DB Oracle support
  • Compile oracle stored procedure
  • Discover slow queries in the db
• Steps in the Bookkeeping database
  • Modifying steps
• Processing pass in the Bookkeeping
• Bookkeeping down time
• Automatic updating of the productionoutputfiles
• Automatic updating of the prodrunview
• Managing partitions
  • jobs table partitions
  • files table partitions
• Database monitoring
• ProductionOutputFiles table
• Fill ProductionOutputFiles table
• Consistency checks
• Bookkeeping database schema