About Gisung

Gisung · 02-06-2017

Hi, AllI have a problem to create data archiving process for NLS Test.I created the DB connection and verified the success.- DBCO- ADBC_TEST_CONNECTIONBut when I tried to create data archiving process, the menu is not shown like below.Are there any a...

Gisung · 10-10-2016

Hi all, Check db process is usually running long and affecting performance. This procedure reads every database page from disk into memory and performs various consistency checks. In check mode, sp_iqcheckdb performs an internal consistency check...

Gisung · 05-25-2016

Hi,As you know SAP Sybase IQ does not support the Adaptive Server data types UNIVARCHAR.But You can get the univarchar data from ASE using insert location statement.Here are steps to get the univarchar data.[In ASE] 1> create table univarchar_test(c...

Gisung · 03-23-2016

1. ProblemUnable 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...

Gisung · 03-16-2016

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 -...

Gisung · 12-22-2017

Hi, Here are my steps to test. 1. vi test.sql[hpita:/bjeon] cat test.sql select* from sysobjects; OUTPUT TO 111 FORMAT ASCII QUOTE ''DELIMITED BY '|' WITH COLUMN NAMES;2. Run sql using dbisql[hpita:/bjeon] dbisql -c dsn=dba -nogui -q test.sql3. [...

Gisung · 12-20-2017

Hi, Try to test with the following query. select* from sysobjects; OUTPUT TO 111 FORMAT ASCII QUOTE ''DELIMITED BY '|' WITH COLUMN NAMES; Best Regards,Gi-Sung Jang

Gisung · 12-20-2017

Yes, Here is a KBA regarding a changed behavior of utility in IQ16.1. 2534299 - Failed to start utility db in IQ16.1 due to Invalid database server command line error.

Gisung · 11-27-2017

Hi, You can find the path of iqmsg file with the following sql. select * from sysdbfile where dbfile_name='IQ_SYSTEM_MSG'; And I want to see the output of "sysam diag" on the E:\SYBASE_IQ_16.0\SYSAM-2_0\bin\ Best Regards,Gi-Sung Jang

Gisung · 11-20-2017

Hi, Please post the error message in iqmsg file and the output of sysam diag (~/SYSAM-2_0/bin).ex) /home2/gjang_home/SYSAM-2_0/bin>./sysam diag IQ is to checkout the license validation when starts up.And if there are any problems regarding licens...

User Statistics

User Activity

Question about DAP.

New system stored procedure to diagnose corrupted tables and columns.

How to get the univarchar data from ASE.

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

How to avoid installation problems with java (jvm).

Re: is this a bug in sybase iq?

Re: How can one get teh columns headers (names) in sybase IQ extraction

Re: Does IQ16.1 change the utility_db behavir?

Re: Sybase IQ 16.0 No sysam license avaliable error.

Re: Sybase IQ 16.0 No sysam license avaliable error.