SAP IQ

Significant News Item regarding BusinessObjects & SAP IQ

For those who may be interested: As of January 2016 all net new purchases (and version upgrades) of the BusinessObjects BI Suite now include 8 Cores of SAP IQ, 8 Cores of SAP Data Integrator and 1 SAP PowerDesigner (Data Architect) Concurrent Session License. These items now become a standard part of the Bill of Materials and are included at no additional cost.  This new offering replaces the BusinessObjects “Analytics …

Read More »

Restore database ..Rename – parallel creating of dbfiles

I am currently migrating a relatively small IQ 16 database to a new location. However, the pre-allocated size of 4 Main and 4 Temp dbfiles is 1 TB each. Creating those files sequentially one-by-one  in an NFS based environment is taking forever. RESTORE database ‘/sybase/PBW_NLS/data/PBW_NLS.db’ FROM ‘/sybase/PBW_NLS/saparch_1/SAPPBWDB.IQfullbkp ‘ RENAME IQ_SYSTEM_MAIN  TO   ‘/sybase/PBW_NLS/data/SYSTEM_MAIN_00.IQ’ RENAME SAPIQDBSPACE001_001  TO   ‘/sybase/PBW_NLS/nlsdata_1/PBW_NLS/PBW_NLS_01.IQ’  RENAME SAPIQDBSPACE001_002  TO   ‘/sybase/PBW_NLS/nlsdata_2/ PBW_NLS/PBW_NLS_02.IQ’ (…) Is there any way to create those files …

Read More »

Enhancement of iqunload utility for data unload

In the past, iqunload utility could be executed only with migration mode (-au) or schema unload mode (-n). However, table data unload functionality was added to iqunload utility by CR 773343. ——————————————————————————————————- ESD05 773343 The IQUNLOAD tool has been enhanced to support unload of a current iq database schema and data. ——————————————————————————————————- [Affected IQ version] 15.x : after 15.4 ESD5 16.0 : after 16.0 SP10.x IQ 16.0 SP08.x version does …

Read More »

How to change password on command line

SAP IQ 15 and above allows users to change their password using “NEWPWD”  dbisql connection string parameter 1. Create user    (DBA)> create user myuser identified by sql 2. login to SAP IQ server as myuser $ dbisql -c “uid=myuser;pwd=sql;eng=iqmpx1010c” -nogui (myuser)> quit 3. Change myuser password  using  “NEWPWD” connection string parameter $ dbisql -c “uid=myuser;pwd=sql;NEWPWD=newpass;eng=iqmpx1010c” -nogui (myuser)> quit 4.  Connect to SAP IQ server as myuser to confirm that …

Read More »

Verify SAP IQ Database Consistency for Disaster Recovery

You have regular backups, and a disaster recovery plan.  But would it execute smoothly if worst came to worst? Here’s one way you might check database consistency on your disaster recovery system. Incremental Backup Flavors Many SAP IQ administrators make incremental backups between full backups. You are probably familiar with the two kinds of incremental backups. INCREMENTAL INCREMENTAL_SINCE_FULL All blocks changed since the last backup of any kind (FULL or …

Read More »

Upgrading SAP IQ: Uninstall the Old Version First

When upgrading SAP IQ on a Windows or Unix platform, be sure to uninstall the existing version before installing the new version. It is not recommended that you either install the new version over top of the existing installation or to a different folder on the same server. Failure to uninstall first could result in unexpected behavior running the new version.  On Windows, environment and registry settings are global, and …

Read More »

SAP IQ 16 SP10.10

SAP IQ 16 sp10.10 is available for download for all platforms from support portal. CoverLetter with critical bug fixes have been attached. http://support.sap.com/swdc Support Packages and  Patches – I – SYBASE IQ – SYBASE IQ 16.0 AIX  – 64 bit   IQSERV160010P_10-20011178.TGZ HP-UX on IA64 64bit   IQSERV160010P_10-20011179.TGZ Linux on Power BE 64bit   IQSERV160010P_10-20011181.TGZ Linux on x86_64 64bit IQSERV160010P_10-20011180.TGZ Solaris on SPARC 64bit IQSERV160010P_10-20011183.TGZ Solaris on x86_64 64bit   …

Read More »

‘Cannot use view ‘v1’ because it is invalid.’ error.

I’m going to share with you about an error below happened when querying against a view. It happened on the IQ 16.0 SP10 PL08 and the reproduction scenario is as below. ============================================================== T1. Creation of table & view create table jerry(a int, b int, c int ); insert jerry values(1,1,1);commit; create view v1 as select * from jerry ; T2. Alter the schema of the referenced table. alter table jerry …

Read More »

How to assigns a priority to each query waiting in the -iqgovern queue.

1. Problem Unable to increase the value of IQGOVERN_PROIRITY option for an individual user. >> set option gjang.iqgovern_priority=1 [Error] Could not execute statement. Invalid setting for option ‘IQgovern_priority’ SQLCODE=-201, ODBC 3 State=”42000″ Line 1, column 36 The following options are related to setting the query priority. IQGOVERN_PRIORITY ? Assigns a numeric priority (1, 2, or 3, with 1 being the highest) to queries waiting in the processing queue. IQGOVERN_MAX_PRIORITY ? …

Read More »

How to avoid installation problems with java (jvm).

1. Problem     The setup.bin hangs in the ‘Forking JAVA in launching installer’ stage.          [ How to debug]          – If you add the following to setup.bin, it shows that setup process stopped at the “Forking JAVA step”.            1) ./setup.bin -Dlax.debug.all=true -Dlax.debug.level=3         [LAX debugging]       /BI/gjang/prod/ebf25475>./setup.bin -Dlax.debug.all=true -Dlax.debug.level=3      Preparing to install…      …      Launching installer…      ========= VM Command Line ============================================ …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration