ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Data Repository Vertica DB is slow to start

book

Article ID: 145860

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

I would like to understand what the Vertica DB is slow to start when you start it up again after you've properly shutdown the vertica db.  In my case, it was shut down for Linux patching, system rebooted, then I go back in to start it again. 
 
It will eventually start but it seems to take a long time. 

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

Vertica needs to read in a lot of data even when the database is properly shut down. Start times of 5-10 minutes are common.  The log below shows how much time it is taking in each phase of start up.

<CATALOG_DIRECTORY>drdata/v_drdata_node0001_catalog/startup.log