Skip to main content
Solved

Database Task Schedule: Performing tests

  • June 12, 2026
  • 3 replies
  • 30 views
M
Sidekick (Customer)
Forum|alt.badge.img+7

Hello,

 

I just want to know that I have configured the database task schedules in UAT environment and performed the functional tests. The database tasks are:

 

  • Shrink LOB Segments
  • Validate Indexes
  • Foundation1 Monitoring
  • Rebuild Indexes
  • Update Rowkey Column

I want to know that are functional tests performed inside IFS Cloud is enough to move them to Production or tests at Database level is required.

 

Regards,

Mani

Best answer by Lingesan08

Hello,

 

I just want to know that I have configured the database task schedules in UAT environment and performed the functional tests. The database tasks are:

 

  • Shrink LOB Segments
  • Validate Indexes
  • Foundation1 Monitoring
  • Rebuild Indexes
  • Update Rowkey Column

I want to know that are functional tests performed inside IFS Cloud is enough to move them to Production or tests at Database level is required.

 

Regards,

Mani

Hi ​@MANI0202 ,

Functional testing inside IFS Cloud is the main acceptance for these — they are standard IFS-delivered tasks, so separate database-level testing is not required. However, since these are DB maintenance operations, I'd recommend verifying a few things at database level in UAT before promoting:

  1. Background job logs — confirm each task completed without errors or warnings across multiple runs, not just once
  2. Index status — after Rebuild/Validate Indexes, check no indexes are left in UNUSABLE state (DBA_INDEXES)
  3. Space results — after Shrink LOB Segments, confirm space was actually reclaimed (DBA_SEGMENTS before/after)
  4. Execution duration — note how long each task takes in UAT; you'll need this to size the PROD maintenance window

For Production:

  • Schedule Rebuild Indexes and Shrink LOB in an off-peak window — they are resource-intensive
  • Don't stack the heavy tasks at the same time; stagger them
  • Ensure a recent backup exists before the first PROD run

If all UAT runs are clean and the durations are acceptable, you're good to move them to PROD.

3 replies

M
Do Gooder (Customer)
Forum|alt.badge.img+1
  • mmcdonald
  • Do Gooder (Customer)
  • June 12, 2026

These are the ones documented (still correct)

 

https://docs.ifs.com/techdocs/24r2/070_remote_deploy/010_installing_fresh_system/300_initial_system_configuration/007_background_processing/020_configure_scheduled_tasks/

 

 

    L
    Hero (Partner)
    • Lingesan08
    • Answer
    • June 12, 2026

    Hello,

     

    I just want to know that I have configured the database task schedules in UAT environment and performed the functional tests. The database tasks are:

     

    • Shrink LOB Segments
    • Validate Indexes
    • Foundation1 Monitoring
    • Rebuild Indexes
    • Update Rowkey Column

    I want to know that are functional tests performed inside IFS Cloud is enough to move them to Production or tests at Database level is required.

     

    Regards,

    Mani

    Hi ​@MANI0202 ,

    Functional testing inside IFS Cloud is the main acceptance for these — they are standard IFS-delivered tasks, so separate database-level testing is not required. However, since these are DB maintenance operations, I'd recommend verifying a few things at database level in UAT before promoting:

    1. Background job logs — confirm each task completed without errors or warnings across multiple runs, not just once
    2. Index status — after Rebuild/Validate Indexes, check no indexes are left in UNUSABLE state (DBA_INDEXES)
    3. Space results — after Shrink LOB Segments, confirm space was actually reclaimed (DBA_SEGMENTS before/after)
    4. Execution duration — note how long each task takes in UAT; you'll need this to size the PROD maintenance window

    For Production:

    • Schedule Rebuild Indexes and Shrink LOB in an off-peak window — they are resource-intensive
    • Don't stack the heavy tasks at the same time; stagger them
    • Ensure a recent backup exists before the first PROD run

    If all UAT runs are clean and the durations are acceptable, you're good to move them to PROD.

    Thanks, Lingesan R
    M
    Sidekick (Customer)
    Forum|alt.badge.img+7
    • MANI0202
    • Author
    • Sidekick (Customer)
    • June 12, 2026

    Hello ​@Lingesan08 

     

    For Shrink LOB Segment, the job ran successfully but I found the “allocated lob size when done” reduced.

     

    Is this okay or it needs investigation.

     

    Thanks & Regards,

    Mani

    Terms & ConditionsAccessibility statement