Dear all,
One customer is checking with me -- how to migrate their current ASA to IQ as we know the IQ's syntax is same to ASA -- so he is thinking there must some fast/safe method to migrate so that there's no need manual re-coding.
But I can ...
Dear All,
I want to create a docker image for sybase ASE/IQ. And I got some problems these days -- while the DB running, there always are much more higher extra IO on the host generated by kworker threads. It impacts the IO performance heavily. I c...
Dear Experts,
As we know -- In IQ 15.x -- if we turn off the global option "minize storage" -- Then the following created FP indexes will be created default as FLAT FP. Yet, I found in IQ16.x -- even I turned it off -- the FP index still created a...
Dear Experts,
I'm new to netweaver, I just installed a nw7.50 over ASE and want to have a look on the dbacockpit inside. The installation completed without error, and the "SAP_BASIS_SETUP_INITIAL_CONFIG" also completed successfully. But when I ran...
Dear All,
As we know -- once we have a VLDB license with TB type, we can use --
sp_iqlmconfig 'allow','IQ_VLDBMGMT',<number>
-- to enable it on IQ16.x
But here one customer's old IQ server is only 15.2 and in the license I can see -- the T...
Hi, Chirs, Thanks for your reply. Yes, At first, I checked with customer if they have PD to reverse-engineering this ASA, and found they don't have it... As we know -- PD is not a free software. And if we ask customer to purchase a PD just for ...
Hi Roland, Thanks for your reply. Yes, I know ASA is the meta-data store for IQ -- that .db and .log file for IQ. But this time -- customer is requesting migration their BO's ASA to IQ. So only export/load table is not enough. I need something...
I find the key --Because the docker's host is SLES12 so all the FS on it are all default BTRFS, And this BTRFS will generate lots of jounal logging activities while DB running on docker container.So now with putting the device file on ext3/ext4 FS an...
I've made another test on this docker container with fio not ASE... And found -- while fio produced IO-- there are also some extra kworer IOs -- but they are only a few... Only 2.6% of the IO from fio...ffdd4b529ece:/tmp/installer # fio --ioengine=li...
