Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th October 2006, 10:04
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
Arrow Which Set Commands Do You Use? Why?
Baan: Baan IVc3
C/S: None/Unknown

Hello All , I wonder something . ON BW Config , which commands do you use? Especially for DB ? may be something can be useful for ADMIN.
In genaral I use BSE_LANG command with it.
Quote:
WHICH SET COMMANDS DO YOU USE? WHY?
THanks ALL

COMMANDS ARE THAT

Quote:
================================================================================
1. Options from the bshell6.x (ntbshell.exe on NT)
(can also be set with "-- [options] [program...]"
in the Option Dialog window in bw or BECS)
(*) = documented in bshell6.2

-appendlog : append to logfile (only useful with -logfile option)
-ba : connect with ba display server
-bx : connect with bx display server
-deftext : show bshell texts
-dbgbdbact : show the Baan database activities initiated from the bshell
-dbgcpu : use debug version of the cpu
-dbgdata : show datainput options (not for fields!)
-dbgenums : show loading of enums
-dbgfdev : debug file access
-dbgfile : show successfully opened sequential files
-dbgflow : show program flow (6.1c.06.03+)
-dbgfun : debug functions
-dbggpvar : debug get & putvar
-dbginstr : show bshell cpu instructions
-dbgjvmi : show JavaVM integration actions
-dbglck : show locking errors
-dbglts : debug Language Translation Support (LTS) X=dump, B=RDD, F=component
-dbgmem : show all memory statistics (see below)
-dbgmemblk : show memory usage per block
-dbgmemfree : show free memory list
-dbgmemtot : show total memory usage
-dbgmemused : show used memory list
-dbgmesg : stop debugger when warning message is sent to the display server (*)
-dbgmulact : show process actions (activate,sleep,kill etc.)
-dbgobj : show object information
-dbgorb : debug ORB (Object Request Broker) integration (where available)
-dbgpty : debug pseudo terminals pty
-dbgref : show reference paths
-dbgrefer : show references
-dbgres : show loaded resources
-dbgsched : debug scheduler
-dbgsrdduse : show srdd usage
-dbgsrv : show bdb server type
-dbgstack : dump 3GL stack traces on function entry
-dbgtss : Show TSS-diagnostics and go to debugger on TSS-error
-deftext : show bshell texts
-delay : delay for seconds before continuing (useful for attaching with a debugger: set breakpoint at the function 'delay_ready')
-dsunicode : communicate with the display driver using Unicode strings (*)
-keeplog : don't remove the logfile after ending the bshell
-logfile : log stdout/stderr output in
-logtag <tag> : used together with -logfile. The <tag> is used in the logfile and is especially useful when logging from multiple bshells (*)
-logtime : add time stamps to bshell log output (combine with -dbgmulact)
-mdebug : display bshell messages sent to display server
-nodebug : disable debugger.
-nolog : stdout and stderr will go to the controlling terminal (if possible - on remote connection no output will appear)
-nounicode : don't read unicode files $BSE/lib/unicode/*.(N2U|U2N). (*)
-r : show resources
-server : run as a server without UI
-set var=val : set environment variable 'var' to 'val' (see below)
-vV : show program version
-windownames : pass unique window names to user interface for testtools (*)

--------------------------------------------------------------------------------
1.1 Unknown options
-auto
-text "vi %s" vi +%d %s

================================================================================
2. With the option "-- -set var=val" you can also pass other
environment setting to the bshell (and underlaying processes)
that have a special meaning.

Tracing and Logging:
--------------------------------------------------------------------------------
2.1 "-- -set TT_SQL_TRACE=value (or added values)" Logging
information from the Baan database driver. Maximum value = 0277367
-set TT_SQL_TRACE=0000001 Parse Query Strings and show information
-set TT_SQL_TRACE=0000002 Show RDD usage of Query
-set TT_SQL_TRACE=0000004 Final Dump info queries
-set TT_SQL_TRACE=0000020 Database Actions ("Operand" "Operator")
-set TT_SQL_TRACE=0000040 Show queries wih their QID
-set TT_SQL_TRACE=0000100 Mode of query
-set TT_SQL_TRACE=0000200 Show query exec. times
-set TT_SQL_TRACE=0001000 Show table dependencies (matrices)
-set TT_SQL_TRACE=0002000 Show calls of internal SQL functions
-set TT_SQL_TRACE=0004000 Show query eval. plan (client+server)
-set TT_SQL_TRACE=0010000 Show quey ev. plan (server)
-set TT_SQL_TRACE=0020000 Show all full table scans
-set TT_SQL_TRACE=0040000 Database Action Messages
-set TT_SQL_TRACE=0200000 Query Distribution Plan
-set TT_SQL_TRACE=0400000 Show current time to level of milliseconds

--------------------------------------------------------------------------------
2.2 "-- -set BDB_DEBUG=value (or added values)" Sets debugging
link between client and server
-set BDB_DEBUG=0001 Server information
-set BDB_DEBUG=0002 Communication between Server and Client
-set BDB_DEBUG=0004 Show information on currently set locks
-set BDB_DEBUG=0010 Show references between tables
-set BDB_DEBUG=0040 Show all tables using native storage format
-set BDB_DEBUG=0100 Permissions

--------------------------------------------------------------------------------
2.3 "-- -set DBSLOG=value (or added values)" Logging information
from the online processing of the database driver.
-set DBSLOG=0000001 Data dictionary info of tables
-set DBSLOG=0000002 Query info (SQL level 1)
-set DBSLOG=0000004 Query info (SQL level 2)
-set DBSLOG=0000010 Row action info
-set DBSLOG=0000020 Table action info
-set DBSLOG=0000040 Transaction info
-set DBSLOG=0000100 DBMS input/output data (SQL level 2)
-set DBSLOG=0000200 Admin file info (SQL drivers)
-set DBSLOG=0000400 DBMS SQL statements
-set DBSLOG=0001000 General debug statements
-set DBSLOG=0002000 Query processing info
-set DBSLOG=0004000 Data buffering info (communication)

--------------------------------------------------------------------------------
2.4 "-- -set BLAT=option (may be added and combined)" starts
Binary Logging And Tracing, spawning the whole range
from bshell to the database driver (6.1c.06.03+/7.1c.02+)
-set BLAT="off"
-set BLAT="default" default is "t0 s1 t1 s1 t2 s0 t3 s0 th 5 t4 s011 th 5"
-set BLAT="logfile ""<path_and_filename>""" redirects output to filename (defaults to $BSE/tmp/blat.log)
t0 = proc
-set BLAT="proc s 00" no logging of Baan processes and their hyerarchy
-set BLAT="proc s 01" logging Baan processes and their hyerarchy
t1 = sess
-set BLAT="sess s 000" no logging lifetime of Baan sessions and propagation
-set BLAT="sess s 001" ... on 3GL/BDB level (client)
-set BLAT="sess s 002" ... on DBS level (database driver)
-set BLAT="sess s 004" ... on DBDL level (database driver/RDBMS integration)
-set BLAT="sess s 010" ... on DBS level (audit driver)
t2 = retry
-set BLAT="retry s 00" no logging of handling retry.points
-set BLAT="retry s 01" logging of handling retry.points
t3 = trans
-set BLAT="trans s 000" (commit and abort) transaction related logging off
-set BLAT="trans s 001" ... on 3GL/BDB level (client)
-set BLAT="trans s 002" ... on DBS level (database driver)
-set BLAT="trans s 004" ... on DBDL level (database driver/RDBMS integration)
-set BLAT="trans s 010" ... on DBS level (audit driver)
-set BLAT="trans th value" ... allows logging with threshold value [seconds]
t4 = sql
-set BLAT="sql s 000000" no logging of handling queries
-set BLAT="sql s 000001" ... 3GL/BDB level: Log aggregated information
-set BLAT="sql s 000002" ... 3GL/BDB level: Log all actions
-set BLAT="sql s 000010" ... 3GL/BDB level: Log BaanSQL text
-set BLAT="sql s 000020" ... 3GL/BDB level: Log bind variables
-set BLAT="sql s 000040" ... 3GL/BDB level: Log selected data
-set BLAT="sql s 000100" ... DBdriver Level2: Log aggregated information
-set BLAT="sql s 000200" ... DBdriver Level2: Log all actions
-set BLAT="sql s 001000" ... DBdriver Level2: Log BaanSQL text
-set BLAT="sql s 002000" ... DBdriver Level2: Log bind variables
-set BLAT="sql s 004000" ... DBdriver Level2: Log selected data
-set BLAT="sql s 010000" ... DBdriver Level1: Log aggregated information
-set BLAT="sql th value" ... allows logging with threshold value [seconds]

Note: Processing of the loggings is supposed to be done by using tools. See $BSE/api/blat (and Perl module Blat.pm)
Note2: Instead of spaces as (the default) separator an alternative (set by BLATSEP) can be used to make it possible to have one argument on the environment variable assignment. -set BLATSEP=_
Note3: Not all options are implemented yet
Note4: the value of the threshold will allow only values that exceed the threshold value to be logged, may also be "off" or "default".
Note5: bls6.x converts BLAT logfiles to readable format: open source example included
Note6: btop6.x reads the top <n> queries from the BLAT logfiles (logged with "sql s 011" option).

--------------------------------------------------------------------------------
2.5 "-- -set BAAN_ART_TRACE=[0|1|5]" Set this variable to debug
the ARTM code in the application scripts.
-set BAAN_ART_TRACE=0 Tracing disabled.
-set BAAN_ART_TRACE=1 Basic tracing. Transactions are shown.
-set BAAN_ART_TRACE=5 The trace information is send to the file $BSE/tmp/bshell.pid.

Common BShell environment settings
--------------------------------------------------------------------------------
2.6 Several common settings that influence the user environment overrule user settings in RDD

-set BAAN_WIN_TITLE=string_value sets a caption for the menu browser other than the default, can be composed with:
%C Company Name
%c Company Number
%h Host Name
%p Package Combination
%s Session Code
%S Session Name
%u Userid
-set BSE_COMPNR=company to login into specific company, note package combination must match or no difference with current package combination
-set BSE_LANG=value to change language (1=Dutch, 2=English, 3=French, 4=German etc.)
-set BSE_TMP=temporary folder to use a temporary folder other than $BSE/tmp
-set COMP_NR=company same as BSE_COMPNR
-set DS_AS=bshell_name [for ba6.1 only, to specify a specific bshell name from ipc_info] : like setting Bshell Name in bw
-set DS_MAX_WAIT=value the timeout duration [seconds] in which BW has to respond to the sync message, and override the default of 30 seconds
-set DS_TIMEOUT_DETECT=value the timeout duration [minutes] before the bshell starts sending a sync message to BW
-set PACKAGE_COMB=package combination to login into specific package combination
-set SESSION_TIMEOUT=value the number of minutes the bshell can be inactive before it terminates itself, when the timeout is triggered a message is sent to the UI and the bshells stops
-set SUPPRESS_WINHELP=1 if you choose help the baan help appears instead of the windows version of the baan help
-set UI=ascii allows to run bw with an ASCII interface
-set USE_SHM_INFO=value enables or disables shared memory use (*)
-set USER=baan_user to login using a different user (use the same system login with several Baan logins)
-set USR_DBC_RES=file specifies alternative resource file for client to read after the file $BSE/lib/defaults/all is read. Allows to overrule settings in the all file with setting a different value in the specified file

BShell environment settings for specific tasks and applications
--------------------------------------------------------------------------------
2.7 Settings for programmers and other specific tasks
-set AUDIT_FILE_PATH=folder set the location of the audit files
-set BAAN_SCM_GRP=value sets your checkout directory so more everyone that uses the same group can see your changes.
-set BDB_DRIVER=value Sets database specifications
-set BDB_MAX_SERVERS_=value Defines the mechanism for schedule SCHEDULE closing idle server sessions
-set BDB_MAX_SESSION_=value defines mechanism for closing schedule SCHEDULE idle driver sessions
-set BDB_MAX_SESSIONS=value defines number of sessions per driver
-set CUNO_SRC=1 allows for exporting sources (used by Baan PEG with SMT)
-set DBSLOG_LOCK_PROF Specifies lock time above which locks are logged (*)
-set DBSLOG_LOGNAME=file Allows file name to be specified for logging (*)
-set ENABLE_REFMSG=value causes logging of denied update or delete actions (*)
-set LOCK_RETRY=n defines the number of lock retries and the sleep period between retries
-set MAX_RETRY=n the system may return n times to a retry point in case of an abort in an update action, default=10
-set RDS_FULL=value to define max. nr. rows transfered between client and server as one block (good for imports/exports)
-set SSTS_SET_ROWS=value Sets number of rows read ahead (single table single row)
-set TEST_RETRY=n each retry point is triggered n times

dbsinit specifies optimistic or pessimistic reference checking and some MultiByte settings
inf_use_prepare_cache:0 in $BSE/lib/defaults/db_resource turn off the Prepare Statement Cache
-set USR_DBS_RES=file Specifies alternative resource file for server

BShell environment settings that I do not know :-)
--------------------------------------------------------------------------------
2.7 Some unknow variables
-set BMASK=02
-set CORE=
-set LINES=
-set USE_BMASK_AS_ABSOLUTE=1
Reply With Quote
  #2  
Old 13th October 2006, 15:26
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,905
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
This is the only command I use "-set TT_SQL_TRACE=0000200 Show query exec. times". I use this to see where execution times might be slow. Other than that I do not think I have used any of the rest of the commands.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 16th October 2006, 07:08
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
Thanks mark , I am still waiting board's comments ...
Reply With Quote
  #4  
Old 16th October 2006, 13:48
csecgn's Avatar
csecgn csecgn is offline
Guru
 
Join Date: Aug 2004
Location: Cologne/Germany
Posts: 300
csecgn is on a distinguished road
Baan: IVc4 SP14 (Tools SP 21) ; LN 6.1 (Testing) - DB: Oracle - OS: Solaris
For an easier change to another company/VRC without modifying my user
(only a new bwc file is needed)
-set COMP_NR=company same as BSE_COMPNR
-set PACKAGE_COMB=package combination to login into specific package combination

Sometimes other for special debugging

I need the sources for export new/modified scripts/...
-set CUNO_SRC=1 allows for exporting sources (used by Baan PEG with SMT

hth

Regards
csecgn
Reply With Quote
  #5  
Old 16th October 2006, 14:08
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
That is good. I don't use comp_nr, if I need , I use change company command on baan. Thank you for your information. I am still waiting other friends's comments.

Thanks All
Reply With Quote
  #6  
Old 18th October 2006, 07:10
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
I am still waiting other's comments !!! WAke up .

Thanks .
Reply With Quote
  #7  
Old 25th February 2008, 22:19
baanpro baanpro is offline
Junior Member
 
Join Date: Feb 2005
Posts: 15
baanpro is on a distinguished road
Baan: baan5b, BaanIV, ERP LN - DB: oracle 9i, informix, sql - OS: AIX5L, HPUX, Windows
Is there any way to set user ufile parameters through BW command?
I have requirement to set Monday as 1st day of week for certain reports. But on company data, Sunday is set as 1st day of week. We cannot change company data, the only workaround we found was change the 1st_dow vaule to 2 instead of 1 in user ufile. Just wondering is there any way to do it runtime, in session OR set it for user when he log in thro' BW command?
Reply With Quote
  #8  
Old 8th September 2008, 10:49
amrit_shirodkar amrit_shirodkar is offline
Junior Member
 
Join Date: Feb 2008
Posts: 16
amrit_shirodkar is on a distinguished road
Baan: Baan 5C - DB: SQL server 2005 - OS: Windows XP
Nice information. Thanks Mr. Suleyman
Reply With Quote
  #9  
Old 8th September 2008, 14:29
sprasad sprasad is offline
Junior Member
 
Join Date: Aug 2008
Posts: 26
sprasad is on a distinguished road
Baan: Baan Ln - DB: SQL 2000 - OS: Windows 2003 server
For creating a file which will give details of time taken by functions in session,reports
-set PROFILE_ALL=1 -set PROF_DIR=path where file has to be created

For logging in another Package combination.. where OS login is same.
-set USER=user_name.
Reply With Quote
  #10  
Old 9th September 2008, 11:22
dhanushya dhanushya is offline
Junior Member
 
Join Date: Feb 2008
Posts: 16
dhanushya is on a distinguished road
Baan: ln6 - DB: sql - OS: windows xp
Quote:
Originally Posted by mark_h View Post
This is the only command I use "-set TT_SQL_TRACE=0000200 Show query exec. times". I use this to see where execution times might be slow. Other than that I do not think I have used any of the rest of the commands.
I tried to use it but i dont know where to see the exec time??
can u please help...
Reply With Quote
  #11  
Old 9th June 2009, 05:58
MilindV's Avatar
MilindV MilindV is offline
Senior Member
 
Join Date: Feb 2008
Location: Hyderabad, India
Posts: 107
MilindV is on a distinguished road
Baan: LN, BaaN-IVc4, BaaN-Vc - DB: SQL Server - OS: Windows, Unix
Unhappy BAAN_WIN_TITLE doesnt work in Baan4c4

Hi All,

-- -set BAAN_WIN_TITLE=%S|%c|%p|%h not working in baan4c4.

Any suggestions, why it is not working in baan4c4?
I use same in Ln, it works perfectly.

Thanks & Regards
MilindV
Reply With Quote
  #12  
Old 11th June 2009, 19:56
drezzzz drezzzz is offline
Member
 
Join Date: Dec 2008
Posts: 30
drezzzz is on a distinguished road
Baan: mk - DB: bisam - OS: AIX
For those, if any, who use MK, it seems that the -set option is use through :
# export TT_SQL_TRACE=0002000
# mkas 2> file.log

It also seems that no parameters other than TT_SQL_TRACE work...
__________________
********************
My web site
Reply With Quote
  #13  
Old 16th January 2014, 20:03
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 514
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
i used to be able to just open one session with a -set command but i can't remember it now. anybody knows what it is?
Reply With Quote
Sponsored Links
  #14  
Old 16th January 2014, 20:45
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 133
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
you don't need the -set part, just put the session code directly in the command field.
__________________
Gary
Reply With Quote
  #15  
Old 16th January 2014, 21:44
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 514
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
Quote:
Originally Posted by GaryEd View Post
you don't need the -set part, just put the session code directly in the command field.
Thank you Gary. I found it out after I already sent the message. It worked
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
text.write does not return new text number ahulikavi Tools Development 10 4th September 2017 11:03
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
BW client parameters lsatenstein Tools Administration & Installation 2 31st January 2012 21:29
Debug Baan shell NPRao Tools Administration & Installation 2 28th May 2003 13:22
Detected database server termination (help! aide! ayuda! hilfe! ayuto! hellup! •‚¯!)! Francesco Operating Systems & Databases 15 20th July 2002 11:37


All times are GMT +2. The time now is 15:27.


©2001-2017 - Baanboard.com - Baanforums.com