Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve Sybase IQ data insertion errors". In daily operation, I believe many people have doubts about how to solve Sybase IQ data insertion errors. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to solve Sybase IQ data insertion errors". Next, please follow the editor to study!

Users will report an error Temporary space limit exceeded when inserting data into IQ. At first glance, they think that IQ TEMP DBSPACE is full.

Actually, it's not IQ Main Store, it's Catalog database: SQL Anywhere, we need to adjust the-cl,-ch in the parameters to make it larger.

Then you also need to adjust the temp directory to change it from the / tmp default directory to the larger / data01/iqdm.

1. Query select file_name from SYS.SYSDBFILE where dbfile_name = 'temporary'

/ tmp/.SQLAnywhere/iqdm_s06/tmp/tmp_000000

two。 Referenc

2053506-SAP IQ: ASA/Catalog Temporary space limit exceeded. How IQ use temporary file in / tmp?

3. Restart after modifying the parameters.

At this point, the study on "how to solve the error of Sybase IQ insertion data" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.