ASE connection timeout
Hi,
Environment: ASE 15.0.3 ESD#1 on Solaris.
Attempts to log into the ASE failed with the following
message:
CT-LIBRARY error:
ct_connect(): user api layer: internal Client
Library error: Read from the server has timed out.
CT-LIBRARY error:
ct_connect(): network packet layer: internal net
library error: Net-lib operation timed out
At that time, one task was running a I/O & tempdb intensive
report and another was loading another database.
My questions are:
1. Isn't it true that all tasks have yield points at which
it returns control to the ASE engine to execute other tasks
waiting in the runnable queue? In that case, the above error
would not have occured.
2. Are there any ASE parameters that I need to look at which
could remedy this situation?
Thanks in advance.
ATT
|
0 |
|
ATT
12/13/2010 2:05:02 PM
sybase.ase.administration
7058 articles. 
2 followers.
1 Replies
2254 Views
You might need to check the network timeouts for your O/S. On 12/13/2010 7:05 AM, ATT wrote: > Hi, > > Environment: ASE 15.0.3 ESD#1 on Solaris. > > Attempts to log into the ASE failed with the following > message: > > CT-LIBRARY error: > ct_connect(): user api layer: internal Client > Library error: Read from the server has timed out. > CT-LIBRARY error: > ct_connect(): network packet layer: internal net > library error: Net-lib operation timed out > > At that time, one task was running a I/O& tempdb intensive > report and another was loading another database. > > My questions are: > > 1. Isn't it true that all tasks have yield points at which > it returns control to the ASE engine to execute other tasks > waiting in the runnable queue? In that case, the above error > would not have occured. > > 2. Are there any ASE parameters that I need to look at which > could remedy this situation? > > Thanks in advance. > ATT
|
|
0 |
|
Tommy
12/30/2010 10:37:26 PM
Similar Artilces:
ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE Any information is welcome jean-fran�ois ASA supports a fairly large sub-set of Transact-SQL, so if you write your stored procedures and triggers in ASA using T-SQL, you should be able to create scripts that will run against both ASE and ASA. If you're planning to do this though, I would suggest developing your database schema against ASA, since everything you write in T-SQL in ASA will be supported on ASE, but the reverse is not true. Check out the section in the ASA documentation entitled "Tra...
ASE to ASE
Hi, Is anyone out there doing ASE to ASE replication using SQL remote? If you are have created your own version of the SSEXTRACT utility to set up a replicant database in ASE rather than ASA? Or does anyone know if SYBASE has created a version SSEXTRACT for use with ASE to ASE replication? Thanks in advance Doug Trainer Hi Douglas, I thought the SQL Remote Replication support in ASE11.5 was meant for a consolidate-database only (by design)! At least that was what Sybase said when they announced support for SQL Remote technology support in ASE11.5. I will be happy to...
ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to ASE and ASE To ASE ? You should start with the Help file and then ask specific questions: Data Replication with SQL Remote PART 5. Appendix APPENDIX A. Enterprise and Anywhere: Differences There are many differences, so begin there. -- David Fishburn Sybase Please only post to the newsgroup BH Ong <bhong@tm.net.my> wrote in message news:01bf4b98$33183580$7ccdc8c8@virtual-branch... > What are the differents in terms of configuring SQL Remote Between ASA to > ASE and ASE To ASE ...
Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup. My current installation consists of a Consolidated ASE & 2 Remote ASE's. My attempt to add another Remote ASE to the existing installation consists of these steps: - Install the sqlremote system objects in the new Remote - Install the stable queues in the new Remote - Manually extract a bcp file of the shared table from the Cons server - Configure the Cons server for another subscriber - Configure the new Remote's shared table, publications, & subscriptions. - Manually b...
Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, We are in the process of planning the upgrade of our ASE 12.5.4 dataservers to ASE 15.x. What is the most recommended way to upgrade ASE dataservers from ASE 12.5.4 to ASE 15.x? Potential options: 1) Install new instances of ASE 15.x and load database dumps from our ASE 12.5.4 dataservers to the newly installed ASE 15.x dataservers. - OR - 2) Use the ASE upgrade utility (sqlupgrade) to upgrade our existing ASE 12.5.4 dataservers to ASE 15.x. What are the Pros vs. Cons for loading a 12.5.4 database into a 15.x ASE dataserver versus performing an ASE dataserv...
How can I set connection timeout in ASE?
Hi! I want to force disconnect client connection after a inactivity period. Is it possible in ASE 12.0? Thank you. best regard -- dkf I don't believe it's possible without building your own mechanism to do so. mc Look at turning on the resource limits. dkf wrote: >Hi! > >I want to force disconnect client connection after a inactivity period. Is >it possible in ASE 12.0? >Thank you. >best regard > >-- >dkf > > ...
When using MS-ADO to connect to ASE using ASE OLEDB/ODBC driver the record count is -1
Hi VB 6 application connecting to ASE 12.5 (NT) using OLEDB/ODBC drivers. Gets a problem. He retrieve rows from the database - WORKS Fine!!! But as soon as he wants to see how many rows was returned the recordcount returns -1. He gets this problem connecting using ODBC and OLEDB. He gets the recordcount from the recordset object's recordcount property. This is what I found on the MSDN online manuals: RecordCount Property - ADO Indicates the current number of records in a Recordset object. Applies To Recordset Remarks Use the RecordCount property to find out how many r...
sql-remote between ASE and ASE
hello! sql-remote document don't give us help with replication with ASE and ASE. i need detail how to do it. i use ASE12 + NT4.0 + SQL Remote6.0.2 . i test it in the list 1�� define messagetype : smtp 2�� define use_name :one is publisher,the other is remote user_name 3�� define publisher,publication,subscription 4��execute ssremote.exe to receive or send message I failed at the step of extract database .i don't extract the database . please help me ,tell me the datail of sql-remote confige. Thanks a lot , ...
sql remote ase to ase
can I use sql remote ro replicate data form ase to ase or only from asa to ase and asa to asa ? I would also recommend that you read over the following tech doc; Implementing ASE to ASE Server SQL Remote Replication http://my.sybase.com/detail?id=1009730 Ian Bater iAnywhere Solutions Reg Domaratzki wrote: > Just be aware of the limitations pointed out in the documentation when using ASE as a remote database. > > Replication and Synchronization Guide > PART 4. Appendixes > APPENDIX A. Enterprise and Anywhere: Differences > > Limitations ...
SQL Remote ASE
hi did anybody know when SQL Remote support blob (image, text) replicacion for ASE - ASE? our company need this feature. joan caceres electro sur este s.a.a. Hello Joan, Support for image and text replication with SQL Remote went in as of ASA 6 mainline, 6.0.01.1256, and SA maintenance 5.5.04 build 1938. Regards, Bob Bauer Sybase Technical Support jmcd wrote: > hi > > did anybody know when SQL Remote support blob (image, text) replicacion for > ASE - ASE? > > our company need this feature. > > joan caceres > electro sur este ...
Solaris ASE to Linux ASE
We are looking into using Replication Server to Set up Warm Standby of Production ASE databases - Primary site being on Solaris platform - Standby Copy on Linux. Does any utilize this configuration ? What is the best way to initialize data on the Standby Server ? What other issues should I be concerned with ? Hi, Technically you can setup Warm Standby across platforms. It may work well too with Replication Server. However, you cannot dump and load the databases (cross platform dump and load not supported), hence there will be issues when you need to resync your databases. Eac...
ASE workgroup
hi, what the diference between ASE workgroup and ASE Enterprise, to which systems apply workgroup or enterprise. is an AlphaServer 4000 (DIGITAL SERVER 7305) workgroup and unix and ASE 12.0 will be avaliable for true unix (DEC UNIX). thanks in advance ...
ASE connection
Hi, Is it possible to access a ASE 12.5 database directly from a Pocket PB application? miguelcarvajal555@hotmail.com wrote... > Hi, > Is it possible to access a ASE 12.5 database directly from a Pocket PB > application? Not at this time. If you are using MobiLink you can have the MobiLink server connect directly to ASE. But the PPB application cannot connect directly to ASE at this time. I believe there is the possibility of PPB connecting to a local ASA database that can have a proxy table that points to an ASE database but I haven't tried that mysel...
ASE Connection
Hi All, I am having problems creating an ASE connection profile in PB(7.0.3). PBSYC70.dll is in the shared folder but PB still tells me it cannot load the drivers. Any ideas? thanks dave 1) Do you have open client installed? Is it in the path? Do you have a SYBASE environment set properly? 2) Is PBSYC70.DLL in the path? (I am just checking and assume that this is not the problem) /ck "Dave Larkins" <davidl@mint.net> wrote in message news:DOmtyoVYBHA.361@forums.sybase.com... > Hi All, > > I am having problems creating an ASE connectio...
Could it be possible to take scripts from ASA and load them in an ASE Any information is welcome jean-fran�ois ASA supports a fairly large sub-set of Transact-SQL, so if you write your stored procedures and triggers in ASA using T-SQL, you should be able to create scripts that will run against both ASE and ASA. If you're planning to do this though, I would suggest developing your database schema against ASA, since everything you write in T-SQL in ASA will be supported on ASE, but the reverse is not true. Check out the section in the ASA documentation entitled "Tra...
ASE to ASE
Hi, Is anyone out there doing ASE to ASE replication using SQL remote? If you are have created your own version of the SSEXTRACT utility to set up a replicant database in ASE rather than ASA? Or does anyone know if SYBASE has created a version SSEXTRACT for use with ASE to ASE replication? Thanks in advance Doug Trainer Hi Douglas, I thought the SQL Remote Replication support in ASE11.5 was meant for a consolidate-database only (by design)! At least that was what Sybase said when they announced support for SQL Remote technology support in ASE11.5. I will be happy to...
ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to ASE and ASE To ASE ? You should start with the Help file and then ask specific questions: Data Replication with SQL Remote PART 5. Appendix APPENDIX A. Enterprise and Anywhere: Differences There are many differences, so begin there. -- David Fishburn Sybase Please only post to the newsgroup BH Ong <bhong@tm.net.my> wrote in message news:01bf4b98$33183580$7ccdc8c8@virtual-branch... > What are the differents in terms of configuring SQL Remote Between ASA to > ASE and ASE To ASE ...
Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup. My current installation consists of a Consolidated ASE & 2 Remote ASE's. My attempt to add another Remote ASE to the existing installation consists of these steps: - Install the sqlremote system objects in the new Remote - Install the stable queues in the new Remote - Manually extract a bcp file of the shared table from the Cons server - Configure the Cons server for another subscriber - Configure the new Remote's shared table, publications, & subscriptions. - Manually b...
Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, We are in the process of planning the upgrade of our ASE 12.5.4 dataservers to ASE 15.x. What is the most recommended way to upgrade ASE dataservers from ASE 12.5.4 to ASE 15.x? Potential options: 1) Install new instances of ASE 15.x and load database dumps from our ASE 12.5.4 dataservers to the newly installed ASE 15.x dataservers. - OR - 2) Use the ASE upgrade utility (sqlupgrade) to upgrade our existing ASE 12.5.4 dataservers to ASE 15.x. What are the Pros vs. Cons for loading a 12.5.4 database into a 15.x ASE dataserver versus performing an ASE dataserv...
How can I set connection timeout in ASE?
Hi! I want to force disconnect client connection after a inactivity period. Is it possible in ASE 12.0? Thank you. best regard -- dkf I don't believe it's possible without building your own mechanism to do so. mc Look at turning on the resource limits. dkf wrote: >Hi! > >I want to force disconnect client connection after a inactivity period. Is >it possible in ASE 12.0? >Thank you. >best regard > >-- >dkf > > ...
When using MS-ADO to connect to ASE using ASE OLEDB/ODBC driver the record count is -1
Hi VB 6 application connecting to ASE 12.5 (NT) using OLEDB/ODBC drivers. Gets a problem. He retrieve rows from the database - WORKS Fine!!! But as soon as he wants to see how many rows was returned the recordcount returns -1. He gets this problem connecting using ODBC and OLEDB. He gets the recordcount from the recordset object's recordcount property. This is what I found on the MSDN online manuals: RecordCount Property - ADO Indicates the current number of records in a Recordset object. Applies To Recordset Remarks Use the RecordCount property to find out how many r...
sql-remote between ASE and ASE
hello! sql-remote document don't give us help with replication with ASE and ASE. i need detail how to do it. i use ASE12 + NT4.0 + SQL Remote6.0.2 . i test it in the list 1�� define messagetype : smtp 2�� define use_name :one is publisher,the other is remote user_name 3�� define publisher,publication,subscription 4��execute ssremote.exe to receive or send message I failed at the step of extract database .i don't extract the database . please help me ,tell me the datail of sql-remote confige. Thanks a lot , ...
sql remote ase to ase
can I use sql remote ro replicate data form ase to ase or only from asa to ase and asa to asa ? I would also recommend that you read over the following tech doc; Implementing ASE to ASE Server SQL Remote Replication http://my.sybase.com/detail?id=1009730 Ian Bater iAnywhere Solutions Reg Domaratzki wrote: > Just be aware of the limitations pointed out in the documentation when using ASE as a remote database. > > Replication and Synchronization Guide > PART 4. Appendixes > APPENDIX A. Enterprise and Anywhere: Differences > > Limitations ...
SQL Remote ASE
hi did anybody know when SQL Remote support blob (image, text) replicacion for ASE - ASE? our company need this feature. joan caceres electro sur este s.a.a. Hello Joan, Support for image and text replication with SQL Remote went in as of ASA 6 mainline, 6.0.01.1256, and SA maintenance 5.5.04 build 1938. Regards, Bob Bauer Sybase Technical Support jmcd wrote: > hi > > did anybody know when SQL Remote support blob (image, text) replicacion for > ASE - ASE? > > our company need this feature. > > joan caceres > electro sur este ...
Solaris ASE to Linux ASE
We are looking into using Replication Server to Set up Warm Standby of Production ASE databases - Primary site being on Solaris platform - Standby Copy on Linux. Does any utilize this configuration ? What is the best way to initialize data on the Standby Server ? What other issues should I be concerned with ? Hi, Technically you can setup Warm Standby across platforms. It may work well too with Replication Server. However, you cannot dump and load the databases (cross platform dump and load not supported), hence there will be issues when you need to resync your databases. Eac...
ASE workgroup
hi, what the diference between ASE workgroup and ASE Enterprise, to which systems apply workgroup or enterprise. is an AlphaServer 4000 (DIGITAL SERVER 7305) workgroup and unix and ASE 12.0 will be avaliable for true unix (DEC UNIX). thanks in advance ...
ASE connection
Hi, Is it possible to access a ASE 12.5 database directly from a Pocket PB application? miguelcarvajal555@hotmail.com wrote... > Hi, > Is it possible to access a ASE 12.5 database directly from a Pocket PB > application? Not at this time. If you are using MobiLink you can have the MobiLink server connect directly to ASE. But the PPB application cannot connect directly to ASE at this time. I believe there is the possibility of PPB connecting to a local ASA database that can have a proxy table that points to an ASE database but I haven't tried that mysel...
ASE Connection
Hi All, I am having problems creating an ASE connection profile in PB(7.0.3). PBSYC70.dll is in the shared folder but PB still tells me it cannot load the drivers. Any ideas? thanks dave 1) Do you have open client installed? Is it in the path? Do you have a SYBASE environment set properly? 2) Is PBSYC70.DLL in the path? (I am just checking and assume that this is not the problem) /ck "Dave Larkins" <davidl@mint.net> wrote in message news:DOmtyoVYBHA.361@forums.sybase.com... > Hi All, > > I am having problems creating an ASE connectio...
Web resources about - ASE connection timeout - sybase.ase.administration Connection - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...
iMedia Connection: Interactive Marketing News, Features, Podcasts and Video - iMediaConnection.comIf you send more email, you might make more money. Then again, you might destroy your reputation and revenue stream. Here's how to know what ...
HTTP persistent connection - Wikipedia, the free encyclopedia... tacked on to an existing protocol. If the browser supports keep-alive, it adds an additional header to the request: Following this, the connection ...
MOTHER’S DAY: Facebook Examines Connections Between Moms, KidsWith Mother’s Day on the calendar this coming Sunday, Facebook examined the relationships between mothers and their children on the social network, ...
Police tear open roof to arrest man in connection with stabbing murderPolice have torn open the roof of a Gold Coast home to arrest a man in connection with the stabbing death of 16-year-old Michael Brack.
Paris attacks: Belgium connection probed as terrorist past of Brussels district of Molenbeek under spotlight ...Prosecutors reveal a growing Belgian connection to the deadly Paris attacks, focusing on a poor Brussels district.
Half of data connections by top 500 Android apps are 'covert' with no effect on user experienceResearchers at the Massachusetts Institute of Technology have discovered that half of the communications connections established by the top free ...
Don’t Let Great Content Fall on Deaf Ears: Know your Connection Strategy... via employee newsletter when it should have come through small-group manager meetings All of these and more are the result of a faulty connection ...
Brussels Connection Under Spotlight After Paris Killings(EurActiv) — Prosecutors on Sunday disclosed a growing Belgian connection to the Paris attacks as Premier Charles Michel conceded that a Brussels ...
Be Goofy, Smile At Your Baby: Protection Begins with Connection, Pediatrician Says
VideoPart 3 of a series Andrew Garner wears silly ties and finds it easy to make a goofy face. These are valuable tools for charming the babies ...
VideoPart 3 of a series Andrew Garner wears silly ties and finds it easy to make a goofy face. These are valuable tools for charming the babies ...
Resources last updated: 11/22/2015 2:59:06 PM