on 09-11-2015 9:17 PM
Hi All,
We have newly installed Sybase IQ.
Now the first problem why I cant find any installable for AIX SCC.
?
Second thing I have installed the SCC on my desktop and tried to connect to IQ server on AIX, its asking for a hostname and port. How do I find out whats the port number ?
Third thing, is there any command line interface like isql in Sybase ase and sqlplus in oracle?
Hi,
Did you saw this Document - https://scn.sap.com/docs/DOC-39627
the SAP IQ Cockpit (sucessor of SCC) is part on any full package of the SAP IQ database archive
Best regards
Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SAP First Guidance - SAP-NLS Solution with SAP IQ | SCN
the URL is working. Are you registered with SCN?
Best Regards Roland
Hi,
There was SP04, SP08 and now SP10 for SAP IQ 16.0. As you are doing a fresh Installation you can start directly with a full Install of SP10.03 as stated in the Document - SAP First Guidance - SAP-NLS Solution with SAP IQ | SCN
Best Regards Roland
Hi,
You can use a command line interface with "dbisql + nogui" as follows.
Ex)
[hpita:/bjeon]dbisql -c "uid=dba;pwd=sql;eng=HPIA16" -nogui
(DBA)> select @@version
@@version
--------------------------------------------------------------------------------------------------------------------------------
SAP IQ/16.0.102.1257/20057/P/sp10.03/ITANIUM/HP-UXi 11.31/64bit/2015-08-26 10:10:16
(1 rows)
Execution time: 0.361 seconds
If you make a odbc file, you can connect to IQ using dsn list.
1) create .odbc.ini file
2) write down the information of IQ
ex) .odbc.ini ($SYBASE/.odbc.ini)
[dba]
uid=dba
pwd=sql
eng=HPIA16
dbn=HPIA16
Commlinks=tcpip{host=10.34.193.108;port=2638}
3) connect to IQ using dsn.
> dbisql -c "dsn=dba" -nogui
==
Gi-sung Jang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes you can start with IQ demo database.
e.g mkdir mydemo
cp $SYBASE/IQ-16_0/demo/mk* /work/mydemo
cd /work/mydemo
./mkiqdemo.sh
it will create IQ demo database. Once IQ database have been created. You can edit iqdemo.cfg for customizing IQ server name and port info and then start IQ server
start_iq @iqdemo.cfg iqdemo.db
SAP IQ reference guide does have complete list of commands and stored procedure
What version of IQ did you installed? You could you use SAP IQ Cockpit, bundled with IQ. hostname should be your IQ server host machine and port should the port on which IQ sever is listening.
For SCC you would be need to install SCC IQ plugin on IQ server host machine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saroj,
Lots of problems, now finally I have installed SAP IQ server suite 16.0 SP10.02 64 bit on AIX.
Now when I open
http://<hostname>:4282/cockpit/# I cannot login using DBA/sql
I am not sure what is wrong.
I cannot follow the guidance document since I am going directly to 16.0.
Can you please make the documentation more clear please since for starters like me I am struggling to get things fixed.
Is dblocate able to locate your demo database? If yes, then stop IQ server and restart it . Stop IQ cockpit and restart IQ cockpit. Clear browser cache, stop and re-lunch browser and wait few min for automatic discovery to work and connect to IQ cockpit. System drop down should have your IQ server
Regarding SCC support on AIX: SCC is only supported on Linux, solaris and management for the full management. Because of JRE limitations on AIX64, SCC is not supported on aix64
You can refer to Roland's First guidance doc for IQ NLS and quick IQ startup and IQ cockpit docs on
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.