DBRep - Beispiel aus dem Wiki "Größe der FHEM-Datenbank ermitteln"

[der-Lolo]

Hallo Zusammen,
ich habe auf einem "frischen" System DBLog und DBRep aufgesetzt - und um zu vermeiden das ich mich irgendwann über eine vollgelaufene DB ärgere wollte ich das Beispiel DBRep aus dem Wiki umsetzen.
Leider funktioniert das nicht wie ich es mir vorgestellt habe. Da ich aber sonst nirgendwo ein Beispiel finde komme ich nicht weiter.

Kann vielleicht jemand mit einem funktionieredem Beispiel weiterhelfen? 

[betateilchen]

Was funktioniert denn bei Dir nicht?

Spontan getestet:

1. mit SQLITE

Code Auswählen Erweitern

get dbRep svrinfo

ergibt das reading

Code Auswählen Erweitern

setstate dbRep 2022-06-12 15:20:46 SQLITE_FILE_SIZE_MB 4

*****

2. mit MYSQL

Code Auswählen Erweitern

get dbrep_2 tableinfo

ergibt die beiden readings

Code Auswählen Erweitern


setstate dbrep_2 2022-06-12 15:27:22 INFO_current.data_length_MB 0.02
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.data_length_MB 6.52


[der-Lolo]

Hallo Udo,
ein reading -

Code Auswählen Erweitern

INFO_history.data_index_length_MB
0.03
2022-06-12 15:10:15

bekomme ich - im Wiki steht aber das die Informationen recht umfangreich wären, dazu gibt es einen Screenshot der deutlich mehr Informationen anzeigt.

https://wiki.fhem.de/wiki/DbRep_-_Reporting_und_Management_von_DbLog-Datenbankinhalten#Gr.C3.B6.C3.9Fe_der_FHEM-Datenbank_ermitteln

Das wundert mich einfach ein bisschen, kann also auch sein das alles gut ist

Gruß aus Berlin,
Michael

[betateilchen]

Naja, insgesamt kommen bei mir auch mehr readings als die beiden genannten.
Aber da Du explizit nach der Größe gefragt hattest, habe ich nur die beiden kopiert.

Das wird bei mysql als Ergebnis geliefert:

Code Auswählen Erweitern


setstate dbrep_2 2022-06-12 15:27:22 INFO_current.collation utf8_bin
setstate dbrep_2 2022-06-12 15:27:22 INFO_current.create_time 2022-03-07 20:11:10
setstate dbrep_2 2022-06-12 15:27:22 INFO_current.data_index_length_MB 0.02
setstate dbrep_2 2022-06-12 15:27:22 INFO_current.data_length_MB 0.02
setstate dbrep_2 2022-06-12 15:27:22 INFO_current.engine InnoDB
setstate dbrep_2 2022-06-12 15:27:22 INFO_current.row_format Dynamic
setstate dbrep_2 2022-06-12 15:27:22 INFO_current.version 10
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.avg_row_length 115
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.collation utf8_bin
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.create_time 2022-03-07 20:12:34
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.data_free_MB 4.00
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.data_index_length_MB 10.03
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.data_length_MB 6.52
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.engine InnoDB
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.index_length_MB 3.52
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.number_of_rows 58964
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.row_format Dynamic
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.update_time 2022-06-12 15:20:08
setstate dbrep_2 2022-06-12 15:27:22 INFO_history.version 10


bei sqlite sind es über 200 readings.

Code Auswählen Erweitern


setstate dbRep 2022-06-12 15:20:46 SQLITE_DB_FILENAME /opt/fhem/sqldb/fhemlog.db
setstate dbRep 2022-06-12 15:20:46 SQLITE_FILE_SIZE_MB 4
setstate dbRep 2022-06-12 15:20:46 SQL_ACCESSIBLE_PROCEDURES N
setstate dbRep 2022-06-12 15:20:46 SQL_ACCESSIBLE_TABLES Y
setstate dbRep 2022-06-12 15:20:46 SQL_ACTIVE_CONNECTIONS 1021
setstate dbRep 2022-06-12 15:20:46 SQL_ACTIVE_ENVIRONMENTS 0
setstate dbRep 2022-06-12 15:20:46 SQL_ACTIVE_STATEMENTS 1021
setstate dbRep 2022-06-12 15:20:46 SQL_AGGREGATE_FUNCTIONS 127
setstate dbRep 2022-06-12 15:20:46 SQL_ALTER_DOMAIN 0
setstate dbRep 2022-06-12 15:20:46 SQL_ALTER_TABLE 1
setstate dbRep 2022-06-12 15:20:46 SQL_ASYNC_MODE 0
setstate dbRep 2022-06-12 15:20:46 SQL_BATCH_ROW_COUNT 0
setstate dbRep 2022-06-12 15:20:46 SQL_BATCH_SUPPORT 0
setstate dbRep 2022-06-12 15:20:46 SQL_BOOKMARK_PERSISTENCE 0
setstate dbRep 2022-06-12 15:20:46 SQL_CATALOG_LOCATION 1
setstate dbRep 2022-06-12 15:20:46 SQL_CATALOG_NAME Y
setstate dbRep 2022-06-12 15:20:46 SQL_CATALOG_NAME_SEPARATOR .
setstate dbRep 2022-06-12 15:20:46 SQL_CATALOG_TERM database
setstate dbRep 2022-06-12 15:20:46 SQL_CATALOG_USAGE 13
setstate dbRep 2022-06-12 15:20:46 SQL_COLLATING_SEQUENCE UTF-8
setstate dbRep 2022-06-12 15:20:46 SQL_COLLATION_SEQ UTF-8
setstate dbRep 2022-06-12 15:20:46 SQL_COLUMN_ALIAS Y
setstate dbRep 2022-06-12 15:20:46 SQL_CONCAT_NULL_BEHAVIOR 0
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_BIGINT 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_BINARY 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_BIT 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_CHAR 33554431
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_DATE 33525505
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_DECIMAL 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_DOUBLE 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_FLOAT 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_FUNCTIONS 1
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_GUID 31723265
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_INTEGER 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_INTERVAL_DAY_TIME 33525505
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_INTERVAL_YEAR_MONTH 33525505
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_LONGVARBINARY 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_LONGVARCHAR 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_NUMERIC 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_REAL 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_SMALLINT 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_TIME 33525505
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_TIMESTAMP 33525505
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_TINYINT 31752191
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_VARBINARY 33554431
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_VARCHAR 33554431
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_WCHAR 33554431
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_WLONGVARCHAR 33554431
setstate dbRep 2022-06-12 15:20:46 SQL_CONVERT_WVARCHAR 33554431
setstate dbRep 2022-06-12 15:20:46 SQL_CORRELATION_NAME 1
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_ASSERTION 0
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_CHARACTER_SET 0
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_COLLATION 0
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_DOMAIN 0
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_SCHEMA 0
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_TABLE 12277
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_TRANSLATION 0
setstate dbRep 2022-06-12 15:20:46 SQL_CREATE_VIEW 1
setstate dbRep 2022-06-12 15:20:46 SQL_CURSOR_COMMIT_BEHAVIOR 2
setstate dbRep 2022-06-12 15:20:46 SQL_CURSOR_ROLLBACK_BEHAVIOR 2
setstate dbRep 2022-06-12 15:20:46 SQL_CURSOR_SENSITIVITY 0
setstate dbRep 2022-06-12 15:20:46 SQL_DATABASE_NAME main
setstate dbRep 2022-06-12 15:20:46 SQL_DATA_SOURCE_NAME dbi:SQLite:dbname=/opt/fhem/sqldb/fhemlog.db
setstate dbRep 2022-06-12 15:20:46 SQL_DATA_SOURCE_READ_ONLY N
setstate dbRep 2022-06-12 15:20:46 SQL_DATETIME_LITERALS 0
setstate dbRep 2022-06-12 15:20:46 SQL_DBMS_NAME SQLite
setstate dbRep 2022-06-12 15:20:46 SQL_DBMS_VER 3.34.1
setstate dbRep 2022-06-12 15:20:46 SQL_DBMS_VERSION 3.34.1
setstate dbRep 2022-06-12 15:20:46 SQL_DDL_INDEX 3
setstate dbRep 2022-06-12 15:20:46 SQL_DEFAULT_TRANSACTION_ISOLATION 8
setstate dbRep 2022-06-12 15:20:46 SQL_DEFAULT_TXN_ISOLATION 8
setstate dbRep 2022-06-12 15:20:46 SQL_DESCRIBE_PARAMETER N
setstate dbRep 2022-06-12 15:20:46 SQL_DM_VER
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_HDBC
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_HDESC
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_HENV
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_HLIB
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_HSTMT
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_NAME libsqlite3odbc.so
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_ODBC_VER 03.00
setstate dbRep 2022-06-12 15:20:46 SQL_DRIVER_VER 01.66.0000
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_ASSERTION 0
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_CHARACTER_SET 0
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_COLLATION 0
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_DOMAIN 0
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_SCHEMA 0
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_TABLE 1
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_TRANSLATION 0
setstate dbRep 2022-06-12 15:20:46 SQL_DROP_VIEW 1
setstate dbRep 2022-06-12 15:20:46 SQL_DYNAMIC_CURSOR_ATTRIBUTES1 0
setstate dbRep 2022-06-12 15:20:46 SQL_DYNAMIC_CURSOR_ATTRIBUTES2 0
setstate dbRep 2022-06-12 15:20:46 SQL_EXPRESSIONS_IN_ORDERBY Y
setstate dbRep 2022-06-12 15:20:46 SQL_FETCH_DIRECTION 63
setstate dbRep 2022-06-12 15:20:46 SQL_FILE_USAGE 2
setstate dbRep 2022-06-12 15:20:46 SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 9
setstate dbRep 2022-06-12 15:20:46 SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 3
setstate dbRep 2022-06-12 15:20:46 SQL_GETDATA_EXTENSIONS 11
setstate dbRep 2022-06-12 15:20:46 SQL_GROUP_BY 3
setstate dbRep 2022-06-12 15:20:46 SQL_IDENTIFIER_CASE 4
setstate dbRep 2022-06-12 15:20:46 SQL_IDENTIFIER_QUOTE_CHAR "
setstate dbRep 2022-06-12 15:20:46 SQL_INDEX_KEYWORDS 0
setstate dbRep 2022-06-12 15:20:46 SQL_INFO_SCHEMA_VIEWS 0
setstate dbRep 2022-06-12 15:20:46 SQL_INSERT_STATEMENT 3
setstate dbRep 2022-06-12 15:20:46 SQL_INTEGRITY N
setstate dbRep 2022-06-12 15:20:46 SQL_KEYSET_CURSOR_ATTRIBUTES1 0
setstate dbRep 2022-06-12 15:20:46 SQL_KEYSET_CURSOR_ATTRIBUTES2 0
setstate dbRep 2022-06-12 15:20:46 SQL_KEYWORDS ABORT,AFTER,ANALYZE,ATTACH,AUTOINCREMENT,BEFORE,CONFLICT,DATABASE,DETACH,EACH,EXCLUSIVE,EXPLAIN,FAIL,GLOB,IF,IGNORE,INDEXED,INSTEAD,ISNULL,LIMIT,NOTNULL,OFFSET,PLAN,PRAGMA,QUERY,RAISE,RECURSIVE,REGEXP,REINDEX,RELEASE,RENAME,REPLACE,ROW,SAVEPOINT,TEMP,TRIGGER,VACUUM,VIRTUAL,WITHOUT
setstate dbRep 2022-06-12 15:20:46 SQL_LIKE_ESCAPE_CLAUSE Y
setstate dbRep 2022-06-12 15:20:46 SQL_LOCK_TYPES 1
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_CATALOG_NAME_LENGTH 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_COLUMNS_IN_GROUP_BY 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_COLUMNS_IN_INDEX 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_COLUMNS_IN_ORDER_BY 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_COLUMNS_IN_SELECT 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_COLUMNS_IN_TABLE 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_COLUMN_NAME_LENGTH 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_CONCURRENT_ACTIVITIES 1021
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_CURSOR_NAME_LENGTH 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_DRIVER_CONNECTIONS 1021
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_IDENTIFIER_LENGTH 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_INDEX_SIZE 140737488224256
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_ROW_SIZE 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_SCHEMA_NAME_LENGTH 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_STATEMENT_LENGTH 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_STMT_OCTETS
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_STMT_OCTETS_DATA
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_STMT_OCTETS_SCHEMA
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_TABLES_IN_SELECT 64
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_TABLE_NAME_LENGTH 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAXIMUM_USER_NAME_LENGTH 0
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_ASYNC_CONCURRENT_STATEMENTS 0
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_BINARY_LITERAL_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_CATALOG_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_CHAR_LITERAL_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_COLUMNS_IN_GROUP_BY 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_COLUMNS_IN_INDEX 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_COLUMNS_IN_ORDER_BY 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_COLUMNS_IN_SELECT 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_COLUMNS_IN_TABLE 2000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_COLUMN_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_CONCURRENT_ACTIVITIES 1021
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_CURSOR_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_DRIVER_CONNECTIONS 1021
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_IDENTIFIER_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_INDEX_SIZE 140737488224256
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_OWNER_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_PROCEDURE_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_QUALIFIER_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_ROW_SIZE 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_ROW_SIZE_INCLUDES_LONG Y
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_SCHEMA_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_STATEMENT_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_TABLES_IN_SELECT 64
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_TABLE_NAME_LEN 1000000
setstate dbRep 2022-06-12 15:20:46 SQL_MAX_USER_NAME_LEN 0
setstate dbRep 2022-06-12 15:20:46 SQL_MULTIPLE_ACTIVE_TXN Y
setstate dbRep 2022-06-12 15:20:46 SQL_MULT_RESULT_SETS N
setstate dbRep 2022-06-12 15:20:46 SQL_NEED_LONG_DATA_LEN N
setstate dbRep 2022-06-12 15:20:46 SQL_NON_NULLABLE_COLUMNS 1
setstate dbRep 2022-06-12 15:20:46 SQL_NULL_COLLATION 1
setstate dbRep 2022-06-12 15:20:46 SQL_NUMERIC_FUNCTIONS 4194305
setstate dbRep 2022-06-12 15:20:46 SQL_ODBC_API_CONFORMANCE 1
setstate dbRep 2022-06-12 15:20:46 SQL_ODBC_INTERFACE_CONFORMANCE 1
setstate dbRep 2022-06-12 15:20:46 SQL_ODBC_SAG_CLI_CONFORMANCE 0
setstate dbRep 2022-06-12 15:20:46 SQL_ODBC_SQL_CONFORMANCE 0
setstate dbRep 2022-06-12 15:20:46 SQL_ODBC_SQL_OPT_IEF N
setstate dbRep 2022-06-12 15:20:46 SQL_ODBC_VER 03.00
setstate dbRep 2022-06-12 15:20:46 SQL_OJ_CAPABILITIES 121
setstate dbRep 2022-06-12 15:20:46 SQL_ORDER_BY_COLUMNS_IN_SELECT N
setstate dbRep 2022-06-12 15:20:46 SQL_OUTER_JOINS Y
setstate dbRep 2022-06-12 15:20:46 SQL_OUTER_JOIN_CAPABILITIES 121
setstate dbRep 2022-06-12 15:20:46 SQL_OWNER_TERM
setstate dbRep 2022-06-12 15:20:46 SQL_OWNER_USAGE 0
setstate dbRep 2022-06-12 15:20:46 SQL_PARAM_ARRAY_ROW_COUNTS 2
setstate dbRep 2022-06-12 15:20:46 SQL_PARAM_ARRAY_SELECTS 3
setstate dbRep 2022-06-12 15:20:46 SQL_POSITIONED_STATEMENTS 0
setstate dbRep 2022-06-12 15:20:46 SQL_POS_OPERATIONS 31
setstate dbRep 2022-06-12 15:20:46 SQL_PROCEDURES N
setstate dbRep 2022-06-12 15:20:46 SQL_PROCEDURE_TERM
setstate dbRep 2022-06-12 15:20:46 SQL_QUALIFIER_LOCATION 1
setstate dbRep 2022-06-12 15:20:46 SQL_QUALIFIER_NAME_SEPARATOR .
setstate dbRep 2022-06-12 15:20:46 SQL_QUALIFIER_TERM database
setstate dbRep 2022-06-12 15:20:46 SQL_QUALIFIER_USAGE 13
setstate dbRep 2022-06-12 15:20:46 SQL_QUOTED_IDENTIFIER_CASE 4
setstate dbRep 2022-06-12 15:20:46 SQL_ROW_UPDATES N
setstate dbRep 2022-06-12 15:20:46 SQL_SCHEMA_TERM
setstate dbRep 2022-06-12 15:20:46 SQL_SCHEMA_USAGE 0
setstate dbRep 2022-06-12 15:20:46 SQL_SCROLL_CONCURRENCY 2
setstate dbRep 2022-06-12 15:20:46 SQL_SCROLL_OPTIONS 17
setstate dbRep 2022-06-12 15:20:46 SQL_SEARCH_PATTERN_ESCAPE \
setstate dbRep 2022-06-12 15:20:46 SQL_SERVER_NAME dbname=/opt/fhem/sqldb/fhemlog.db
setstate dbRep 2022-06-12 15:20:46 SQL_SPECIAL_CHARACTERS
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_DATETIME_FUNCTIONS 7
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_FOREIGN_KEY_DELETE_RULE 15
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_FOREIGN_KEY_UPDATE_RULE 15
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_GRANT 0
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_NUMERIC_VALUE_FUNCTIONS 0
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_PREDICATES 15879
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_RELATIONAL_JOIN_OPERATORS 210
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_REVOKE 0
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_ROW_VALUE_CONSTRUCTOR 11
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_STRING_FUNCTIONS 6
setstate dbRep 2022-06-12 15:20:46 SQL_SQL92_VALUE_EXPRESSIONS 15
setstate dbRep 2022-06-12 15:20:46 SQL_SQL_CONFORMANCE 1
setstate dbRep 2022-06-12 15:20:46 SQL_STANDARD_CLI_CONFORMANCE 1
setstate dbRep 2022-06-12 15:20:46 SQL_STATIC_CURSOR_ATTRIBUTES1 466511
setstate dbRep 2022-06-12 15:20:46 SQL_STATIC_CURSOR_ATTRIBUTES2 3
setstate dbRep 2022-06-12 15:20:46 SQL_STATIC_SENSITIVITY 0
setstate dbRep 2022-06-12 15:20:46 SQL_STRING_FUNCTIONS 148760
setstate dbRep 2022-06-12 15:20:46 SQL_SUBQUERIES 31
setstate dbRep 2022-06-12 15:20:46 SQL_SYSTEM_FUNCTIONS 4
setstate dbRep 2022-06-12 15:20:46 SQL_TABLE_TERM table
setstate dbRep 2022-06-12 15:20:46 SQL_TIMEDATE_ADD_INTERVALS 0
setstate dbRep 2022-06-12 15:20:46 SQL_TIMEDATE_DIFF_INTERVALS 0
setstate dbRep 2022-06-12 15:20:46 SQL_TIMEDATE_FUNCTIONS 917504
setstate dbRep 2022-06-12 15:20:46 SQL_TRANSACTION_CAPABLE 2
setstate dbRep 2022-06-12 15:20:46 SQL_TRANSACTION_ISOLATION_OPTION 9
setstate dbRep 2022-06-12 15:20:46 SQL_TXN_CAPABLE 2
setstate dbRep 2022-06-12 15:20:46 SQL_TXN_ISOLATION_OPTION 9
setstate dbRep 2022-06-12 15:20:46 SQL_UNION 3
setstate dbRep 2022-06-12 15:20:46 SQL_UNION_STATEMENT 3
setstate dbRep 2022-06-12 15:20:46 SQL_USER_NAME
setstate dbRep 2022-06-12 15:20:46 SQL_XOPEN_CLI_YEAR 1992