2 Replies Latest reply on Aug 1, 2014 5:33 PM by Bill Robinson

    Share your database settings?

    richard mcleod

      Could anyone with a 5-10k server environment using sql jdbc share their blasadmin database settings?

       

      blasadmin -a show database all

       

      We're experiencing some crazy tcp connection issues on our appservers and I'm trying to identify if our database settings in blasadmin are standard. (feel free to strip your connection string, user, password)

       

      Also if anyone knows... is the com.microsoft.sqlserver.jdbc.SQLServerDriver using the JdbcOdbc.dll in NSH/jre/bin?

       

      Here is what I have

       

      bladmin:*>show database all

      show database all

      [Database]

      AutoBatchEnabled:true

      ConnectionString:

      DatabaseInstrumentationFilePath:

      DatabaseInstrumentationRolloverCount:10

      DatabaseInstrumentationRolloverSize:10000

      DatabaseVersion:8.3.03

      DriverClass:com.microsoft.sqlserver.jdbc.SQLServerDriver

      FetchSize:100

      IdleConnectionTestPeriod:600

      MaxClientConnections:100

      MaxGeneralConnections:100

      MaxIdleTime:600

      MaxJobExecutionConnections:100

      MaxWaitTime:

      MinClientConnections:0

      MinGeneralConnections:0

      MinJobExecutionConnections:0

      MinTimeToLog:0

      Password:

      SqlFiles:

          sql/sqlmap.properties

          sql/streamable_sqlmap.properties

      TransactionAttempts:10

      UserId: