Re: Database server jobs and SQL tuning

[Jerry_C._Phillips@xxxxxxxxxxxx]

So what are the pros and cons then if the database was just created in a library
and manually started the journalling instead of a creating the database in a
collection?

Jerry Phillips









pytel@us.ibm.com on 05/17/2000 08:32:56 AM

Please respond to MIDRANGE-L@midrange.com
                                                                                
                                                                                
                                                                                


                                                              
                                                              
                                                              
 To:      MIDRANGE-L@midrange.com                             
                                                              
 cc:      (bcc: Jerry C. Phillips)                            
                                                              
                                                              
                                                              
 Subject: Re: Database server jobs and SQL tuning             
                                                              









> he has _33_ instances of the QZDASOINIT job servicing his user profile


Every separate ODBC connection will start a separate job.
Reduce number of connections.

> what would the difference be if we created our database as an SQL
collection?

No difference as far as performance is concerned.

Alexei Pytel


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---