Skip to main content

%SYSTEM.SQL.xDBC

Class %SYSTEM.SQL.xDBC Extends %SYSTEM.Help [ Abstract, Not ProcedureBlock, System = 4 ]

Methods​

DisplayServerLogs​

ClassMethod DisplayServerLogs(pid As %Library.String = "") As %Status [ Internal, ProcedureBlock = 1 ]

Display server-side ODBC/JDBC logs that were enabled by $SYSTEM.SQL.xDBC.SetServerLog()
Parameter:

pid Process id of the log to display. If not specified, the user will be given a list of PIDs that have logs defined to choose from. Examples:

  • Do $SYSTEM.SQL.xDBC.DisplayServerLogs() // Displays a list of PIDs with server logs the user can choose from to display
  • Do $SYSTEM.SQL.xDBC.PurgeServerLogs(3245) // Displays server log for process id 3245 in this namespace

PurgeServerLogs​

ClassMethod PurgeServerLogs(pid As %Library.String = "*") As %Status [ Internal, ProcedureBlock = 1 ]

Delete server-side ODBC/JDBC logs that were enabled by $SYSTEM.SQL.xDBC.SetServerLog()
Parameter:

pid Process id of the log global to purge. "*" is the default, which means purge all logs for this namespace Examples:

  • Do $SYSTEM.SQL.xDBC.PurgeServerLogs() // Purges all server logs in this namespace
  • Do $SYSTEM.SQL.xDBC.PurgeServerLogs("*") // Purges all server logs in this namespace
  • Do $SYSTEM.SQL.xDBC.PurgeServerLogs(3245) // Purges server log for process id 3245 in this namespace

SetServerLog​

ClassMethod SetServerLog(condition As %Library.String = "", systemWide As %Boolean = 0) As %Status [ Internal, ProcedureBlock = 1 ]

Define the condition that determines if IRIS performs xDBC server-side logging.
Parameter:

condition An ObjectScript expresion that determines if an ODBC/JDBC server process performs server-side logging. This should only be used at the direction of InterSystems Support personell for debugging purposes. Call with condition="" or undefined to turn logging off. systemWide 1/0 flag that determines if the logging condition specified in condition applies to just this namespace, or system wide. The default is 0, the condition applies to just this namespace. Examples:

  • Do $SYSTEM.SQL.xDBC.SetServerLog("1") // Turns logging on for all xDBC connections to this namespace
  • Do $SYSTEM.SQL.xDBC.SetServerLog("$username=""BOBW""",1) // Turns logging on for all connections on this system when the username is BOBW.
  • Do $SYSTEM.SQL.xDBC.SetServerLog("$Get(^log)=1,0) // Turns logging on for all connections to this namespace if the ^log=1.
  • Do $SYSTEM.SQL.xDBC.SetServerLog("",0) // Turns logging off for all connections to this namespace.
  • Do $SYSTEM.SQL.xDBC.SetServerLog("",1) // Turns logging off for all connections to this server.