Databases
StackOverflow2013
Postsdbo
POUsing the db2 variable "DB2DBDFT" to connect to default schema with user / using
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing the db2 variable "DB2DBDFT" to connect to default schema with user / using
    primarykey
    data
    text
    <p>I am trying to write a bash script that does some db2 work. I am facing the issue whereby subshells require db2 connections to be reconnected.</p> <p>Unfortunately, reconnecting every time is dog slow, as around 1000 new connections will need to be made, each taking around a second. Thus I'm looking to avoid these subshell reconnections.</p> <p>Googling around this situation, I have found that there is a way to set the default connection schema using the variable DB2DBDFT. Unfortunately, with this set it takes the linux logged in user name to be the DB schema name you are running as, whereas our system has a different DB user name to the user logged in to bash.</p> <p>1) Is there a way to set the DB2DBDFT variable, but make it so that it can use a "user abc using 123" style syntax, or if there are other variables where you can set these (I have searched but not found them).</p> <p>2) If there is, will this actually save me any time? Obviously if I find a solution I will benchmark, but I'm not sure that even if I find this, it will be quicker, and surely it will slow down all other subshell spawns.</p> <p>3) I'm very open to other suggestions, I've tried piping to while statements rather than calling subshells but then remembered this has the same issues.</p> <p>e.g.</p> <pre><code> result=$(call_procedure "$get_sell_price_old_sql") </code></pre> <p>versus</p> <pre><code> call_procedure "$get_sell_price_old_sql" | while read result_ do result=$result_ done </code></pre> <p>4) I'm sure there are other avenues I've not considered, any advice and suggestions greatly appreciated.</p> <p>Many thanks, Mitch.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMitch Kent
    1. USMitch Kent
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COvariables like DB2DBDFT, DB2USER, DB2PASSWD?
      singulars
      1. POUsing the db2 variable "DB2DBDFT" to connect to default schema with user / using
      1. USDavide
    2. CODavide - in all the IBM documentation I read, I didn't see the DB2USER and DB2PASSWORD variables listed as options. When using google to search for the terms "db2set db2user" or "export db2user" there were no results I found either. If they do indeed exist then that would be great, and I will search again for references.
      singulars
      1. POUsing the db2 variable "DB2DBDFT" to connect to default schema with user / using
      1. USMitch Kent
    3. COwell, I'm pretty sure they exist, since i got finger-muscle trained to write the "db2 connect to $DB2DBDFT user $DB2USER using $DB2PASSWD" string (not password, passwd) in almost every shell, since i had your very same problem ;)
      singulars
      1. POUsing the db2 variable "DB2DBDFT" to connect to default schema with user / using
      1. USDavide
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload