Skip to Content
avatar image
Former Member

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.




Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 08, 2016 at 12:58 PM

    I would suggest reviewing the following First Guidance document:

    It contains a lot of detail about using IQ as the BW NLS, but to answer your question - Yes, you should have a separate DBSpace for the NLS data.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Chris Baker

      Hi Chris,

      Thanks for this.. Bad news though, we have decided to recreate the db instead.. the iq db.. due to the data in the new dbspace has incorrect values... then when the iq db is up, we tried to archive and it seems that the old dap are still pointing to the old settings..

      any recommendation how to fix this? we tried to delete the dap, but it is having error now.. 😔

      something like error in accessing the relocated data (archive or near-line storage)..

      We do not know what to do next.. SAP is not yet responding to us..

      I tried to look for a fix in SAP but this seems to be a unique scenario.



  • Oct 07, 2016 at 12:07 PM


    As already stated by Chris, the correct SAP IQ DB Implementation is mandantory. See the SAP First Guidance Document for that - SAP First Guidance - SAP-NLS Solution with SAP IQ

    Best Regards Roland

    Add comment
    10|10000 characters needed characters exceeded