How To: Change the maximum number of streams for DBAccess (SDE)
The default maximum number of active data connections (streams) available per connection in Database Access is eight. The steps below describe how to change the maximum number of active data connections.
Log into ArcSDE on the SDE server machine as user SDE.
Stop the SDE service.
Open the file called $SDEHOME/etc/giomgr.defs in a text editor.
Change the value of the parameter MAXSTREAMS to the new maximum streams per connection your require.