Forum Discussion

jappliance99's avatar
jappliance99
Level 1
8 years ago

Query types in bptm log

Looking for some information on query types in the bptm log.There are many differnt types listed 1,70,60,70,77,93.
Does anyone know what these refer to? Also,seeing frequent
"Acquiring new connection" messages.

ConnectionCache::connectAndCache: Acquiring new connection for host xxx, query type 1

ConnectionCache::connectAndCache: Acquiring new connection for host xxx,query type 70

ConnectionCache::connectAndCache: Acquiring new connection for host xxx, query type 60

Thanks
  • Marianne's avatar
    Marianne
    Level 6
    8 years ago
    I am wondering why this is important to you... In my 18 years with NBU I have never needed to know this.

    Are you experiencing issues?
    Or just curious?

    Just maybe mph999 knows and can tell us all...
    • mph999's avatar
      mph999
      Level 6
      8 years ago

      It's related to the type of query made to NBDB.

      For example, if you ran bpimagelist -backupid xxx then this would be Q_IMAGE_LIST which will have a 'query type value'.

      Basically, anything starting Q_IMAGE_, Q_CLASS, Q_CLIENT_ are different query types.  There are some other types that escape my memory.