IQ Main Store usage for SAP BW NLS Data
would like to seek HELP and expertise on how to manage the IQ Main Store of SYBASE IQ 16 SP10 to store NLS data that was archived from HANA DB.
We are now in the DEV phase for NLS implem and are starting the archiving.
Solution is working fine for us now since DEV is containing small amount of data. BUT it is a problem in the future if the company wants to go for a multiplex architecture.
What is the Best Practice for storing data to Sybase iq?
As per IQ sizing docu, IQ_SYSTEM_MAIN dbspace manages important db sturctures including the free list, which lists blocks in use, TLV, node-to-node system coomunication for object changes, and other structures for proper operation of Sybase iq. it more space needed in iq_system_main to store user data, more space will be reserved. Also, when adding space to iq_system_main the entire multiplex must be shut down and the nodes sync.
in our case now, the nls tables are in iq_system_main. Should NLS table be in another DBSPace in Main Store? What steps are to be done to have this maintained? Since we also need to ensure that when we have a separate dbspace for nls, we should ensure we limit the access to the iq_system_main.