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:...
This may not apply to your situation, but there's one other way to clear the queue other than zapping. You can temporarily alter the output DSI connection to skip inserts, update, deletes, or truncates for a specific table:For example, to skip inser...
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...