So I had a problem with a replicate DSI connection. It went down with some reasonable error (couldn't insert to the destination table because it didn't exist). So I ran "sysadmin log_first_tran" to get more details about the insert being run.When I...
A normal shutdown command waits for running users queries to finish. Although it doesn't say this on the reference page, apparently a normal shutdown also flushes free space accounting figures and object statistics (link)
I guess I could write my o...
Using "literal autoparam" with the statement cache active is well explained.
But I don't understand the new "enable literal autoparam" setting of 2 ("converts literal values to parameter descriptions only for ad hoc queries")
"Only for ad hoc que...
If you run a Python script like this:
conn = sybpydb.connect(user='user', password='password')
cur = conn.cursor()
cur.execute("if 1=1 select 1")
rows=cur.fetchmany()
for row in rows:
print(f"row={row}")
The fetchmany() command will return the...
A basic piece of code using the ASE Python SDK libraries doesn't work
conn = sybpydb.connect(user='user', password='password')
cur = conn.cursor()
cur.execute("if 1=1 select 1")
# This fetchmany call will return the error:
# sybpydb.ProgrammingError:...
Re: we want these information from ASE's monitoring tables using remote SQL connectionIt looks like a lot of the "amount of resource used" stats are only available from the sp_monitorconfig 'all' command. Sorry.
Re: Is there any necessity to run "installmaster" after applying 1-off/N-off that is received for a SP with PLIf you run the setup.bin installer, and specify a target directory that already has an existing installation, it will ask if you want to do ...
This is only part of what you're asking for, but it's still a useful command: [100] MYSERVER.master-09:48:24-1> sp_monitorconfig "all";
Usage information at date and time: Apr 8 2024 9:48AM.
Name Num_free Num_act...
You said: "I have my interfaces file in a non-standard location"Why don't you use "ct_config(ctx,CS_SET,CS_IFILE,IFILE" to run with an alternate value for IFILE?