0 Replies Latest reply: Dec 30, 2011 5:54 PM by 900399 RSS

    How to set PRAGMA bdbsql_system_memory

    900399
      All,

      I am trying to set PRAGMA bdbsql_system_memory; however getting the following error with all the different combination. Can anyone let me know the correct approach to set this PRAGMA.

      Also, I am trying to set the same from program using sqlite3 API, For which I am first opening the DB using Sqlite3 API then trying to set the PRAGMA. Is this the correct order? Please suggest.



      Different options I have tried; and the corresponding error:
      ==========================================
      Berkeley DB 11g Release 2, library version 11.2.5.2.36: (September 14, 2011)
      Enter ".help" for instructions
      Enter SQL statements terminated with a ";"
      dbsql> pragma bdbsql_system_memory 0x23232323;
      Error: unrecognized token: "0x23232323"
      dbsql> pragma bdbsql_system_memory base 0x23232323;
      Error: near "base": syntax error
      dbsql> pragma bdbsql_system_memory base id 0x23232323;
      Error: near "base": syntax error
      dbsql> pragma bdbsql_system_memory [base id 0x23232323];
      Error: near "[base id 0x23232323]": syntax error
      dbsql> pragma bdbsql_system_memory [base 0x23232323];
      Error: near "[base 0x23232323]": syntax error
      dbsql> pragma bdbsql_system_memory [base segment ID 0x23232323];
      Error: near "[base segment ID 0x23232323]": syntax error
      dbsql> pragma bdbsql_system_memory base segment ID 0x23232323;
      Error: near "base": syntax error
      dbsql> pragma bdbsql_system_memory base_segment_id 0x23232323;
      Error: near "base_segment_id": syntax error
      dbsql> pragma bdbsql_system_memory base_segment_ID 0x23232323;
      Error: near "base_segment_ID": syntax error
      dbsql> pragma bdbsql_system_memory base_segment_ID 23232323;
      Error: near "base_segment_ID": syntax error
      dbsql> pragma bdbsql_system_memory 23232323;
      Error: near "23232323": syntax error

      Thanks,
      -Mano