Sybase Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi,
I would like to know if there is any configuration parameter or procedure from which I could know how many CPUs or cores is used by ASE?
I am using Sybase ASE 16.0 & 15.7.
0
Get MySQL database support online, now!
LVL 2
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Hi,
Is there any way to disable automatic truncating some of monitoring tables (monSysSQLText, monSysStatement) after SELECT operation? It will make my work a lot easier. I found only a note that ASE assumes that DB user don't want to see it again, which is not true in my case.
I am using Sybase ASE 16.0 & 15.7.
0
Hi,
I'd like to update automatically the statistics for single table in SYBASE ASE every 3 days.

If anybody had tried updating automatically the statistics for single table in SYBASE, please share the procedure with me.

Thanks in advance!
0
I had this question after viewing how to automatically retrieve datawindow while the user types the matching char string on sle.

I want to have the user retrieve automatically names from the list by keying letters in a search sle.
I set up the code to filter the data but nothing is happening. I tried the pbm_dwnkey as event id but nothing. I cannot find the pbm_upkey in the event list. I am using PB 12.5.
Thanks
0
Hi,

I'm working in the DATA WAREHOUSE PROJECT, Does anyone have the industry best practices on how to build a  TEST cases.

Such as Tools, Technique, the methodology used?
0
FromDateTime DATE;
   ToDateTime DATE;  
   S_DATE DATE;
   
     S_DATE:=TRUNC(NVL(D_DATE,SYSDATE));

   IF flag='1' THEN
   FromDateTime :=TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 00:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 11:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='2' THEN
   FromDateTime :=TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 11:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 13:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='3' THEN
   FromDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 13:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 15:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='4' THEN
   FromDateTime := TO_DATE(TO_CHAR(s_date,'DD-Mon-YYYY') || ' 15:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 17:00:00', 'DD-MON-YYYY HH24:MI:SS');
   ELSIF flag='5' THEN
   FromDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 17:00:01', 'DD-MON-YYYY HH24:MI:SS') ;
   ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 19:00:00', 'DD-MON-YYYY HH24:MI:SS');  
   ELSE
    FromDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 19:15:01', 'DD-MON-YYYY HH24:MI:SS') ;
    ToDateTime := TO_DATE(TO_CHAR(S_DATE,'DD-Mon-YYYY') || ' 20:15:00', 'DD-MON-YYYY HH24:MI:SS');
   END IF;
0
Hi All,

In one of my PowerBuilder application there is an window which has 'Master' and 'Modified' list. Records present under 'Master' list are original and when any user makes any changes in any one of them or inserts new record then it will be shown under 'Modified' list, till the time it will be authorized by Authorizer.
There is only one datawindow: d_customer which is used for retrieving data in Master and Modified list, depending on the action ( 'I' (Insert), 'M' (Modify) ) performed details will be fetched in 'Master' / 'Modified' list.

My question is when any user updates/inserts any field it should be get highlighted and will be visible to Authorizer in Yellow color in 'Modified' list.
Could you please help me in implementing this problem statement, it will be great help. Thanks in advance.
0
Now that the 12 has a feature of the columnar tables, had anyone did the performance comparision of Sybase IQ to that of Oracle 12c.  Did you use the 12C columnar table feature or  the traditional tables used for the migration. I have 1.8 TB of data going out from IQ to Oracle but not sure on the performance.
0
How to find config id value from the below string? it can be any no of digits, but only digits. Essentially I want to find the value after --configId and  the space till the next space. That configId can be anywhere in the string and can have any no of digits.

String -->
/XX/XXXX/XXXXX/XX/XX -XX -- /xx/xxxx/xxxx/xxxx/xxxxxxx/xxx/xxx/xxxxxxxx.pl --configId 12107 --cfg /xx/xxxx/xxxxxxx/xxxxxx.xml

I am trying this but not working, not being able to get the length of the substring.
----------------------------------------------------------------------------------------------------------------------------------------
select substring(j.command, patindex('%--configId%',j.command)+9, PATINDEX('%[0-9][^0-9]%', j.command) - PATINDEX('%[^0-9][0-9]%', j.command)) from job j
0
Dears,

Is it right that the following 3 commands are not copies into the standby database:
•      select into
•      update statistics
•      Database or configuration options such as sp_dboption and sp_configure

*For select into, can we add this configuration : sp_setrepdbmode pdb, 'S', 'on'  ?
 If so, what about others? Do we have to apply them manually on standby database?
The same concern is about ALTER table in the active database, but for this I think it is replicated, isn’t it?
0
Dears, I was issuing my script for Sybase ASE database maintenance manually, which select some information from sysobjects and sysindexes relying on derived stats and insert those retrieved data into a temp table then iterate through it to rebuild index when it is needed, the details are in the attached file, please find it.

now, I want to execute this file automatically using a batch file, which calls the attached file but unfortunately the file doesn't execute cause the commands such as select into #temp, and select derived-stats and others.
is this right? or I miss some thing, please advice how can I run my script automatically???
rebuild-idx.sql
0

Sybase Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Top Experts In
Sybase Database
<
Monthly
>