Can db2 scripts be automated?



  • I have a scenario where it is necessary to execute some scripts daily.Is it possible to automate the execution via some tools.?



  • Yes, it's possible and in two different ways.

    AST

    Using the Administrative Task Scheduled (ATS) built inside db2 to execute scheduled operations.


    Command Line

    the db2 command can also read command from a file specified from the command line

    The two solution have both pros and cons: the setup of the AST solution requires administrative privileges on the db while the command line doesn't need changes on the database, on the other side the command line version requires to be scheduled using an external cron daemon while the AST use the scheduling service offered by db2



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2