Database shutdown

[Leonxxx86]

Hi all,

I just would like to confirm this, what is going to happen to tserver , cca and icon if db was shutdown? I know tserver will be fine because once it started it doesn't need to go back to the db to write or read anything? and ICON will write to a file but not sure if that file will get corrupted if ICON writes to it for one day?

I think CCA data will be lost as CCA read from stat server and SS will not be able to write to the DB? please advise? thank you

[cavagnaro]

CCA? ODS will write to emergency files and when DB is restored ETL will work.
TServer no impact
ICON, not sure...think also will write backup files

[borkokrz]

ICON similar to ODS will write to PQ file specified in pq-dbname option ... until the end of disk space I suppose.

[hsujdik]

[quote author=borkokrz link=topic=11467.msg52244#msg52244 date=1571896167]
ICON similar to ODS will write to PQ file specified in pq-dbname option ... until the end of disk space I suppose.
[/quote]
Yes. ICON writes to this PQ file (SQLite database file) even during regular operation, before sending to the actual IDB. However, when this file grows large, ICON usually is unable to read from this PQ file fast enough to insert into the IDB, causing the data to be increasingly delayed. You can check if the DB insert is catching up by monitoring ICON`s HTTP interface (just open a browser pointing to the server and port where it is installed).

[kamalnba]

[quote author=Leonxxx86 link=topic=11467.msg52241#msg52241 date=1571875141]
Hi all,

I just would like to confirm this, what is going to happen to tserver , cca and icon if db was shutdown? I know tserver will be fine because once it started it doesn't need to go back to the db to write or read anything? and ICON will write to a file but not sure if that file will get corrupted if ICON writes to it for one day?

I think CCA data will be lost as CCA read from stat server and SS will not be able to write to the DB? please advise? thank you
[/quote]

1. CCA will write to Emergency files and once connectivity is restored data would be transferred to Datamart.

2. TServer will have no impact as it doesn't have any dependency or connection to DB directly and runs as an application on the server.

3. ICON- For this, DS are T-Server, OCS, Config etc. PQ file setting will decide the size and frequency of files which will be stored if DB connectivity loses and once it is backup ETL will copy these files to Informat. In addition to the interaction persistent queue, the ICON maintains a persistent cache for configuration data. If connectivity was lost for longer time, you may need to manually sync the config data by below procedure.

1. In Options of ICON Application, Go to option - Start-cfg-sync set option to 0 and save.
2. Now change the value of option to 1 and save again, Sync will start automatically.

ICON starts synchronization only when it detects the change from 0 to 1. Time for sync will depend on number of changes to be synced.

[Leonxxx86]

Thank you all for your reply! my understanding is that stat server writes to the db via dap but if there is no db connectivity there will be no data in the first place to read by the data sourcer and then write it to the emergency file, isn't that correct?

or we can say stat server writes to the emergency file and when the connectivity backup then data sourcer will write the data to the db 


thank you

[cavagnaro]

StatServer no. No backup