<![CDATA[Sybase Forums,Unix Forums-Sybase Adaptive server|Replication Server|Sun Solaris Unix|Perl| Sybase Training

<![CDATA[Sybase Forums,Unix Forums-Sybase Adaptive server|Replication Server|Sun Solaris Unix|Perl| Sybase Training - All Forums]]> http://www.sybaseteam.com/ Fri, 03 Sep 2010 14:16:11 -0700 MyBB <![CDATA[Trace Flag for Parameterized Stored Procedure Plan Capture]]> http://www.sybaseteam.com/showthread.php?tid=1050 Thu, 02 Sep 2010 12:18:01 -0700 surenrockz http://www.sybaseteam.com/showthread.php?tid=1050
we have been doing some investigation pertaining to Sybase ASE 15.0.3. However during our query performance evaluation, we figured that ASE doesnt seem to show us any parameters information inside a SP Query Plan. Is there a trace flag that we need to set ?

Any help would be greatly appreciated.

Kind Regards
Suren Chaturvedula]]>
we have been doing some investigation pertaining to Sybase ASE 15.0.3. However during our query performance evaluation, we figured that ASE doesnt seem to show us any parameters information inside a SP Query Plan. Is there a trace flag that we need to set ?

Any help would be greatly appreciated.

Kind Regards
Suren Chaturvedula]]> <![CDATA[How to find why log segment is not getting cleared]]> http://www.sybaseteam.com/showthread.php?tid=1047 Mon, 30 Aug 2010 19:35:13 -0700 Satsun http://www.sybaseteam.com/showthread.php?tid=1047
Do we have any system tabkes where we can find why the logsegment/transaction log is not getting cleared? Something similar to what SQL Server has in sys.databases (log_reuse_wait and log_reuse_wait_desc).

If there is no system tables to find this info, can anyone share any way to find why the log is not getting cleared?

Cheers,
Satsun.]]>
Do we have any system tabkes where we can find why the logsegment/transaction log is not getting cleared? Something similar to what SQL Server has in sys.databases (log_reuse_wait and log_reuse_wait_desc).

If there is no system tables to find this info, can anyone share any way to find why the log is not getting cleared?

Cheers,
Satsun.]]> <![CDATA[Correlate SP's SPID and temp db]]> http://www.sybaseteam.com/showthread.php?tid=1045 Wed, 25 Aug 2010 05:55:56 -0700 Ralagarsamy http://www.sybaseteam.com/showthread.php?tid=1045 Please help me to correlate my SP's SPID and temp db being used.
Say for eg; I have a SP sp_sample and i have 3 tempdbs - tempdb1, tempdb2, tempdb3
My user id is not bind to any specific tempdb. So When I run this proc , my process is free to use any of these 3 tempdbs.
In that case, while running Sp , I wanted to find which tempdb is being used.
Thanks]]> Please help me to correlate my SP's SPID and temp db being used.
Say for eg; I have a SP sp_sample and i have 3 tempdbs - tempdb1, tempdb2, tempdb3
My user id is not bind to any specific tempdb. So When I run this proc , my process is free to use any of these 3 tempdbs.
In that case, while running Sp , I wanted to find which tempdb is being used.
Thanks]]> <![CDATA[Document for Sybase sql]]> http://www.sybaseteam.com/showthread.php?tid=1044 Tue, 24 Aug 2010 04:54:24 -0700 Mohammed Rashid http://www.sybaseteam.com/showthread.php?tid=1044
I am new to the Sybase DB, i am trying to get the any document for Sybase DB and SQL. i Beleive sybase use Transact sql.can anyone help me to get this one.

Thank you
Mohammed Rashid.]]>
I am new to the Sybase DB, i am trying to get the any document for Sybase DB and SQL. i Beleive sybase use Transact sql.can anyone help me to get this one.

Thank you
Mohammed Rashid.]]> <![CDATA[Arabic characters displaying junk characters in syabase adaptive server iq 12.7]]> http://www.sybaseteam.com/showthread.php?tid=1040 Sun, 22 Aug 2010 01:32:49 -0700 hellboy http://www.sybaseteam.com/showthread.php?tid=1040
i am facing an issue, i am running query aganst datbase syabase adaptive server iq 12.7,
some of the fields which are update as arabic characters are displayed as junk chaarcters like "????" or boxes when displaying the report.

can anyone please guide me how to troubleshoot this.
i firmly beliveve there is some characters settings

any suggestion is highly appreciated.]]>
i am facing an issue, i am running query aganst datbase syabase adaptive server iq 12.7,
some of the fields which are update as arabic characters are displayed as junk chaarcters like "????" or boxes when displaying the report.

can anyone please guide me how to troubleshoot this.
i firmly beliveve there is some characters settings

any suggestion is highly appreciated.]]> <![CDATA[introduction]]> http://www.sybaseteam.com/showthread.php?tid=1039 Sun, 22 Aug 2010 01:26:09 -0700 hellboy http://www.sybaseteam.com/showthread.php?tid=1039

My name is Janaki Ram.
i am working as sybase developer in kuwait]]>

My name is Janaki Ram.
i am working as sybase developer in kuwait]]> <![CDATA[Configuring procedure cache percent and data cache]]> http://www.sybaseteam.com/showthread.php?tid=1038 Fri, 20 Aug 2010 23:59:58 -0700 skrtripathi http://www.sybaseteam.com/showthread.php?tid=1038 What is data cache ? what amount of data cache i can configure ?]]> What is data cache ? what amount of data cache i can configure ?]]> <![CDATA[Formula to calculate Syabase max memory parameter]]> http://www.sybaseteam.com/showthread.php?tid=1036 Wed, 18 Aug 2010 01:01:29 -0700 Awais http://www.sybaseteam.com/showthread.php?tid=1036
How we can calculate max memory parameter. Suppose i need to set max memory to 4GB. How i can calculate it in terms of pages.

Regards,

Awais]]>
How we can calculate max memory parameter. Suppose i need to set max memory to 4GB. How i can calculate it in terms of pages.

Regards,

Awais]]> <![CDATA[Sybase Replication Server Interview Questions updated]]> http://www.sybaseteam.com/showthread.php?tid=1035 Tue, 17 Aug 2010 08:15:56 -0700 sybanva http://www.sybaseteam.com/showthread.php?tid=1035
Hi Folks,
Just added some more ques for Sybase Replication Server in interviewquestion page @http://sybaseblog.com/interviewquestions/

What is the diffrence between sp_setreplicate and sp_setreptable?
What is the diffrence between route and connections?
How can we check the current replication setup whether it is WS , table level or db level?
What would be the impact of long running tran running in PDB in whole replication setup?
suppose there is temp table in sp and we want to replicate it?
What is the importance of rs_locator table in replication server?
What is dbcc settruc ltm, valid/ignore? When we use this dbcc command?
What is diffrence between rs_zeroltm and dbcc settrucn ltm,valid?
What are the diffrent users in command replication setup?
What is rs_subcmp?

Happy Learning sybase … Smile

Cheers!!!!]]>
Hi Folks,
Just added some more ques for Sybase Replication Server in interviewquestion page @http://sybaseblog.com/interviewquestions/

What is the diffrence between sp_setreplicate and sp_setreptable?
What is the diffrence between route and connections?
How can we check the current replication setup whether it is WS , table level or db level?
What would be the impact of long running tran running in PDB in whole replication setup?
suppose there is temp table in sp and we want to replicate it?
What is the importance of rs_locator table in replication server?
What is dbcc settruc ltm, valid/ignore? When we use this dbcc command?
What is diffrence between rs_zeroltm and dbcc settrucn ltm,valid?
What are the diffrent users in command replication setup?
What is rs_subcmp?

Happy Learning sybase … Smile

Cheers!!!!]]> <![CDATA[Sybase password prompt in sql script]]> http://www.sybaseteam.com/showthread.php?tid=1034 Tue, 17 Aug 2010 04:24:44 -0700 sureng http://www.sybaseteam.com/showthread.php?tid=1034 ${SYBPASS}
use $DATABASE
go
$sp_name '$date'
go
quit
EOF

All the variables are defined in a profile file. Once logged in I am getting a message like

Password:
(1 row affected)
Password:
(5 rows affected)
Password:

I used set nocount on to ignore the update messages. Is there any option to ignore Password: tooo]]> ${SYBPASS}
use $DATABASE
go
$sp_name '$date'
go
quit
EOF

All the variables are defined in a profile file. Once logged in I am getting a message like

Password:
(1 row affected)
Password:
(5 rows affected)
Password:

I used set nocount on to ignore the update messages. Is there any option to ignore Password: tooo]]> <![CDATA[Sybase ASE 12.5.4 on Linux Open power]]> http://www.sybaseteam.com/showthread.php?tid=1033 Tue, 17 Aug 2010 03:45:45 -0700 Shaun Hide http://www.sybaseteam.com/showthread.php?tid=1033 I am trying to install this version on RH Linux. I can create the Backup server, but my main server does not want to created.

Extract from my log

(Jan 20, 2011 1:43:59 PM), Setup.product.install, com.sybase.ismp.ase.wizardbean.ExecCommandWithProg ress$ExecCommandOutputHandler, err, Server 'HITASPJHBPRE01' was not created.

Setup.product.install, com.sybase.ismp.ase.wizardbean.ExecCommandWithProg ress$ExecCommandOutputHandler, err, /sybase/ASE-12_5/bin/dataserver: error while loading shared libraries: libibmc++.so.1: cannot open shared object file: No such file or directory

Please help me with any ideas]]> I am trying to install this version on RH Linux. I can create the Backup server, but my main server does not want to created.

Extract from my log

(Jan 20, 2011 1:43:59 PM), Setup.product.install, com.sybase.ismp.ase.wizardbean.ExecCommandWithProg ress$ExecCommandOutputHandler, err, Server 'HITASPJHBPRE01' was not created.

Setup.product.install, com.sybase.ismp.ase.wizardbean.ExecCommandWithProg ress$ExecCommandOutputHandler, err, /sybase/ASE-12_5/bin/dataserver: error while loading shared libraries: libibmc++.so.1: cannot open shared object file: No such file or directory

Please help me with any ideas]]> <![CDATA[disable role permissions for an user in sybase]]> http://www.sybaseteam.com/showthread.php?tid=1032 Sun, 15 Aug 2010 04:58:09 -0700 Kishor http://www.sybaseteam.com/showthread.php?tid=1032 To revoke a role in sybase from a sybase login, we can use the below

revole role role_name from login_name

or

sp_role "revoke" , role_name, login_name

To disable sso permissions for an user fred

revoke role sso_role from fred

or

sp_role "revoke" , sso_role, fred]]> To revoke a role in sybase from a sybase login, we can use the below

revole role role_name from login_name

or

sp_role "revoke" , role_name, login_name

To disable sso permissions for an user fred

revoke role sso_role from fred

or

sp_role "revoke" , sso_role, fred]]> <![CDATA[What is the Diffrence between 32 bit and 64 bit ASE sybase versions ?]]> http://www.sybaseteam.com/showthread.php?tid=1031 Thu, 12 Aug 2010 04:02:12 -0700 chandrashekhar http://www.sybaseteam.com/showthread.php?tid=1031
can you please proivde details about the exact Diffrences between 32 bit and 64 bit ASE sybase versions ?

As per my understanding , 64 bits is a higher capacity of the host processor on which sybase server runs .

And , thus the size of ase server data cache is higher in 64 bis version that that in 32 bit version .

It would be helpful if get more details , like what is the data cache size in 32 bit version and data cache size in 64 bit version ?]]>
can you please proivde details about the exact Diffrences between 32 bit and 64 bit ASE sybase versions ?

As per my understanding , 64 bits is a higher capacity of the host processor on which sybase server runs .

And , thus the size of ase server data cache is higher in 64 bis version that that in 32 bit version .

It would be helpful if get more details , like what is the data cache size in 32 bit version and data cache size in 64 bit version ?]]> <![CDATA[Sybase's Future - Discussion]]> http://www.sybaseteam.com/showthread.php?tid=1030 Wed, 11 Aug 2010 07:26:33 -0700 dba1 http://www.sybaseteam.com/showthread.php?tid=1030 Does it mean that Sybase will go up soon? Will SAP use Sybase in its ERP applications?]]> Does it mean that Sybase will go up soon? Will SAP use Sybase in its ERP applications?]]> <![CDATA[HVAR Technology for Replication]]> http://www.sybaseteam.com/showthread.php?tid=1029 Tue, 10 Aug 2010 11:38:11 -0700 sybanva http://www.sybaseteam.com/showthread.php?tid=1029

http://www.sybase.com/detail?id=1081513&...tOnly=true

Sybase, Inc., an SAP company (NYSE: SAP), and industry leader in delivering enterprise and mobile software, today announced transformative new features for the latest version of Sybase® Replication Server®, Sybase’s database replication product supporting change data capture, data distribution and synchronization of data across heterogeneous database environments for real-time analytics, reporting, distributed operations and disaster recovery. Sybase Replication Server innovation dramatically reduces latency with moving data between enterprise information stores, addressing challenges with the ever accelerating pace of business.

This latest release includes the following capabilities:

Real Time Loading for Sybase IQ – empowering organizations to deliver real-time analytics from ASE to Sybase IQ and through continuous change data capture (CDC) technology.

Advanced Performance Services – providing high-volume transaction replication using HVAR technology, significantly reducing transaction latency.

New Heterogeneous Capabilities – improving performance in heterogeneous database environments operating Sybase ASE, Oracle®, IBM® DB2® and Microsoft® SQL Server database servers, with parallel Data Server Interface (DSI). Enterprises can also now maintain warm standby applications for Oracle databases.

In-Memory Database Replication – enabling ASE on-disk databases to be replicated to ASE in-memory databases.

Same Thread @

http://sybaseblog.com/2010/08/10/sybase-...echnology/

Cheers,]]>

http://www.sybase.com/detail?id=1081513&...tOnly=true

Sybase, Inc., an SAP company (NYSE: SAP), and industry leader in delivering enterprise and mobile software, today announced transformative new features for the latest version of Sybase® Replication Server®, Sybase’s database replication product supporting change data capture, data distribution and synchronization of data across heterogeneous database environments for real-time analytics, reporting, distributed operations and disaster recovery. Sybase Replication Server innovation dramatically reduces latency with moving data between enterprise information stores, addressing challenges with the ever accelerating pace of business.

This latest release includes the following capabilities:

Real Time Loading for Sybase IQ – empowering organizations to deliver real-time analytics from ASE to Sybase IQ and through continuous change data capture (CDC) technology.

Advanced Performance Services – providing high-volume transaction replication using HVAR technology, significantly reducing transaction latency.

New Heterogeneous Capabilities – improving performance in heterogeneous database environments operating Sybase ASE, Oracle®, IBM® DB2® and Microsoft® SQL Server database servers, with parallel Data Server Interface (DSI). Enterprises can also now maintain warm standby applications for Oracle databases.

In-Memory Database Replication – enabling ASE on-disk databases to be replicated to ASE in-memory databases.

Same Thread @

http://sybaseblog.com/2010/08/10/sybase-...echnology/

Cheers,]]> <![CDATA[Steps for sybase Ase 15 upgrade using Dump and load approach]]> http://www.sybaseteam.com/showthread.php?tid=1028 Tue, 10 Aug 2010 04:39:39 -0700 chandrashekhar http://www.sybaseteam.com/showthread.php?tid=1028 Hi , I have planeed below generic steps as per my understanding for sybase upgrade from ase 12.5 to Ase 15 using Dump and load approach . Please view and provide your inputs / suggestions if any change needed .
Ase 15 upgrade using Dump and load approach .
1 . Install sybase ASE 15 on new unix host .
2. Build new Sybase ASE 15 DATA SERVER on new host .
3. Copy the logins , roles from old server ( ase12.5) to new server (ase15) .
4. Initialize new devices and create new databases on new server .
4. Load the newly created ase15 databases from the dumps of databases from old (ase12.5) server .
5. set up the important configuration parameters on new server as per ase15 features.]]> Hi , I have planeed below generic steps as per my understanding for sybase upgrade from ase 12.5 to Ase 15 using Dump and load approach . Please view and provide your inputs / suggestions if any change needed .
Ase 15 upgrade using Dump and load approach .
1 . Install sybase ASE 15 on new unix host .
2. Build new Sybase ASE 15 DATA SERVER on new host .
3. Copy the logins , roles from old server ( ase12.5) to new server (ase15) .
4. Initialize new devices and create new databases on new server .
4. Load the newly created ase15 databases from the dumps of databases from old (ase12.5) server .
5. set up the important configuration parameters on new server as per ase15 features.]]> <![CDATA[is it possible to correlate a SPID from a THREAD id?]]> http://www.sybaseteam.com/showthread.php?tid=1027 Tue, 10 Aug 2010 03:50:11 -0700 scarl http://www.sybaseteam.com/showthread.php?tid=1027
Does anyone have any advice as to how to go about this?

Log extract...

PCI(T1): WARNING: pci_malloc; forwarded size 2048000 exceeding max request size 1048528 to the run-time for thread 4648
PCI(T1): ERROR: pci_malloc; Requested size 2048000 exceeds max request size 1048528

If it matters, running ase 15.0.3 esd2 on this particular server.]]>
Does anyone have any advice as to how to go about this?

Log extract...

PCI(T1): WARNING: pci_malloc; forwarded size 2048000 exceeding max request size 1048528 to the run-time for thread 4648
PCI(T1): ERROR: pci_malloc; Requested size 2048000 exceeds max request size 1048528

If it matters, running ase 15.0.3 esd2 on this particular server.]]> <![CDATA[error in init the server in ASE 15 for linux]]> http://www.sybaseteam.com/showthread.php?tid=1026 Mon, 09 Aug 2010 18:20:13 -0700 htamayo http://www.sybaseteam.com/showthread.php?tid=1026

Code:

error creating the DB ASE Server

Code:

error creating the DB ASE Server

so, i was looking for a log file in the install dir - /opt/- but I didn't find anything related to the installation, so my question is:

1. the installation create a log file? where is it?
2. is there a way to restart just the failed steps instead of install everything?

regards]]> <![CDATA[How to create a same login on multiple sybase ASE servers ?]]> http://www.sybaseteam.com/showthread.php?tid=1025 Mon, 09 Aug 2010 02:01:42 -0700 chandrashekhar http://www.sybaseteam.com/showthread.php?tid=1025
I need to create a same login on multiple servers ( on 10 servers ). Can any one please advice if there is any customized shell script which can be used for it ? The script will -
1. read the server name one by one from an input file having list of servers .
2. and create a login with same password and properties on all servers .]]>
I need to create a same login on multiple servers ( on 10 servers ). Can any one please advice if there is any customized shell script which can be used for it ? The script will -
1. read the server name one by one from an input file having list of servers .
2. and create a login with same password and properties on all servers .]]> <![CDATA[Regarding locking the logins in Sybase]]> http://www.sybaseteam.com/showthread.php?tid=1024 Fri, 06 Aug 2010 18:21:13 -0700 pramug http://www.sybaseteam.com/showthread.php?tid=1024
Could someone help me in answering the below questions please..

1. Is there any single commad in sybase to lock all the logins on a particular server ?
2. How to set a non-expiry password for a login ?

Thanks.]]>
Could someone help me in answering the below questions please..

1. Is there any single commad in sybase to lock all the logins on a particular server ?
2. How to set a non-expiry password for a login ?

Thanks.]]>