Hi, We have installed a sybase iq 12 database with about 70GB of data … How do we make a dump of the database ? i mean does anyone know how long it will take to load a dump of this size in ASA IQ ?? It took 2 weeks to load the table with all the data ? how long will it take to recover from a diaster?? – any ideas? thanx, Daniel, Enhance in-the-moment decision-making with SAP IQ , our columnar analytics database software. Request a demo Try now SAP IQ , a Relational Database Management System (RDMS) Enlarge. Previous. SAP IQ relational database software. Next.
Note that if the data source is not an IQ or ASE database , then no loadscript will be generated. External File – PowerDesigner will create a dump file from the source database together with a loadscript to upload it to the IQ server.
8/22/2018 · when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores and three main files. which plays a vital role in Sybase IQ server. 1) Catalog Store –> Stores Metadata in system tables that is needed to run the database . –> Catalog Store is always recommended to create on a file system, Dumps in IQ Hi, We have installed a sybase iq 12 database with about 70GB of data … How do we make a dump of the database ? i mean does anyone know how long it will take to load a dump of this size in ASA IQ ?? It took 2 weeks to load the table with all the data ? how long will it take to recover from a diaster?? – any ideas?, Size and number limitations – SAP, Size and number limitations – SAP, SAP IQ – Wikipedia
