by default the User (SAP<SID>USR) which is used to move the data from the primary Database to the SAP IQ Database doesn't have the necessary permissions to execute the options in Transaction DBACOCKPIT in ABAP.
Furthermore, it is more suitable to move the additional permissions to another user, like already with SAP HANA, called DBACOCKPIT to separate the permissions. To change the necessary IQ Options mentioned in the following Note, these additional permissions are also mandatory.
In addition, you should also know that the DBCO connection create in tx. DBACOCKPIT cannot be used to properly move the data to the IQ Database known as secondary Database. However, the created DBCO connection for NLS/ILM can be used to connect the DBACOCKPIT, as it is enhanced with several additional parameters needed.