Content in 2016

Page 1 out of 2 Pages

• How to make LOAD DB more faster for huge DB? (DBMR2919)

  LOAD DB support 2 option, safe and fast, the default is safe. Set LOAD DB [safe | fast] If set LOAD DB
  29 views
• Why lock-timeout happen while querying system tables? (DBMR2870)

   If you executed SQL statements in some simultaneous connections, for example: delete all records of one table, or drop/create table
  18 views
• How to log CONNECTION and DISCONNECTION information only? (DBMR2835)

  Setting DB_LGSVR=4,5,6 can record traced LOG which include CONNECTION and DISCONNECTION information, and also include SQL COMMAND, SQL COMMIT, SQL
  16 views
• How to encrypt table records for only some columns?

  Can encrypt some columns with encryption UDF as following. A. create function LIBCRYPT.AES_ENCRYPT(string,string) returns string;   create function LIBCRYPT.AES_DECRYPT(string,string) returns string; B. insert
  16 views
• Why and How to rebuild Primary Key?

   When face such as below questions we can also consider to rebuild primary key. For example: Too much index expansion to cause
  28 views
• Why Update Statistics not work for rebuilding index sometime?

  There are some reasons which can cause “update statistics” won’t be executed, for example: after migrate DB from 5.1 to
  34 views
• How to use LoadExternalDB to load DB/table/data online?

  You can use LoadExternalDB to load external DB into local DB directly via DSN. If set unload external 'connection string', dmSQL
  25 views
• How to use sleep function in SQL statements?

  We support an UDF function sleep () for sleeping a while. For example: dmSQL> create function to_date.sleep(int) returns int; dmSQL> select sleep(5);//sleep 5
  12 views
• Why journal full occurs and how to deal with it?

  (1) Journal files size are too small Journal size default value is 4M, if it's caused by journal size too small,
  20 views
• When use new feature -- “set unload fileobj name”?

  “set unload fileobj name” was supported for keeping the FILE OBJECT not re-order during load to new DB. About SYSTEM FILE
  27 views

• 1
  
• 2
  
• →
  
• ⇥

one category up