Re: [U2] 2gig limit sticking into bash shell
Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 BGINPUTTIMEOUT=0 BIMG_BUFSZ=102400 BIMG_FLUSH_BLKS=2 BIMG_MIN_BLKS=10 BPF_NFILES=80 10c22,24 COLORS=/etc/DIR_COLORS.xterm --- CENTURY_PIVOT=1930 CHECK_HOLD_EXIST=0 CHKPNT_TIME=300 11a26,27 COMPACTOR_POLICY=1 CONVERT_EURO=0 12a29 EFS_LCKTIME=0 14a32,34 EXPBLKSIZE=16 FCNTL_ON=0 GLM_MEM_SEGSZ=4194304 15a36,37 GRPCMT_TIME=5 GRP_FREE_BLK=5 23c45,46 IFS=$' \t\n' --- IFS=' ' 24a48,49 JRNL_MAX_FILES=400 JRNL_MAX_PROCS=1 25a51,52 KEYDATA_MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 26a54,55 LB_FLAG=1 LCT_NUM=8 29a59 LOCKFIFO=0 34a65,102 MAX_CAPT_LEVEL=2 MAX_DSFILES=1000 MAX_FLENGTH=1073741824 MAX_LRF_FILESIZE=134217728 MAX_NEXT_HOLD_DIGITS=4 MAX_OBJ_SIZE=307200 MAX_OPEN_FILE=500 MAX_OPEN_OSF=100 MAX_OPEN_SEQF=150 MAX_REP_DISTRIB=1 MAX_REP_SHMSZ=33554432 MAX_RETN_LEVEL=2 MERGE_LOAD=40 MGLM_BUCKET_SIZE=50 MIN_MEMORY_TEMP=64 NFA_CONVERT_CHAR=0 NFILES=1019 NSEM_PSET=8 NULL_FLAG=0 NUSERS=40 N_AFT=200 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_AFT_SECTION=1 N_AIMG=2 N_ARCH=2 N_BIG=233 N_BIMG=2 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 N_GLM_SELF_BUCKET=23 N_PARTFILE=500 N_PGQ=10 N_PUT=8192 N_REP_OPEN_FILE=8 N_SYNC=0 N_TMAFT_BUCKET=19 N_TMQ=10 39a108 PART_TBL=/usr/ud71/parttbl 41,44c110,113 PIPESTATUS=([0]=0) PPID=7616 PROMPT_COMMAND='echo -ne \033]0;${us...@${hostname%%.*}:${PWD/#$HOME/~}\007' PS1='[...@\h \W]\$ ' --- PIPESTATUS=([0]=0 [1]=2) POSIXLY_CORRECT=y PPID=10236 PS1='\s-\v\$ ' 47c116,122 PWD=/home/symeon --- PWD=/usr/ud/accounts/cust855 REP_FLAG=0 REP_LOG_PATH=/usr/ud71/replog SBCS_SHM_SIZE=1048576 SB_FLAG=0 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 49,50c124,140 SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor SHLVL=1 --- SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor:posix SHLVL=3 SHM_ATT_ADD=0 SHM_FIL_CNT=2048 SHM_FREEPCT=25 SHM_GNPAGES=32 SHM_GNTBLS=40 SHM_GPAGESZ=131072 SHM_LBA=4096 SHM_LCINENTS=100 SHM_LMINENTS=32 SHM_LPAGESZ=4096 SHM_LPINENTS=10 SHM_MAX_SIZE=33554432 SHM_MIN_NATT=4 SHM_NFREES=1 SPLIT_LOAD=60 52,55c142,151 SSH_CLIENT=':::87.115.26.230 3539 22' SSH_CONNECTION=':::87.115.26.230 3539 :::78.109.174.173 22' SSH_TTY=/dev/pts/6 SUPPORTED=zh_CN.UTF-8:zh_CN:zh:fr_FR.UTF-8:fr_FR:fr:de_DE.UTF-8:de_DE:de:ja_ JP.UTF-8:ja_JP:ja:es_ES.UTF-8:es_ES:es:en_US.UTF-8:en_US:en --- SSH_CLIENT=':::87.115.26.230 4408 22' SSH_CONNECTION=':::87.115.26.230 4408 :::78.109.174.173 22' SSH_TTY=/dev/pts/7 STATIC_GROWTH_WARN_INTERVAL=300 STATIC_GROWTH_WARN_SIZE=1610612736 STATIC_GROWTH_WARN_TABLE_SIZE=256 SYNC_TIME=0 SYSTEM_EURO=164 SYS_PV=3 TCA_SIZE=128 56a153,157 TERM_EURO=164 TMP=/tmp/ TOGGLE_NAP_TIME=31 TSTIMEOUT=60 UDR_CONVERT_CHAR=1 58a160 UDT_LANGGRP=255/192/129 59a162 UPL_LOGGING=0 61,69c164,167 _=AD psc () { ps --cols=1000 --sort='-%cpu,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } psm () { ps --cols=1000 --sort='-vsz,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } --- VARMEM_PCT=50 WRITE_TO_CONSOLE=0 ZERO_CHAR=131 _= LD_LIBRARY_PATH and PATH are the same all the time. Running unzip with the full path is the same, and whereis unzip only reports the one path of /usr/bin/unzip Also the at command works ! ? I can work with the at command and make it write a completed message at the end and poll for this from the udt process. A strange one tho . Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of regalit...@aol.com Sent: 03 July 2009 16:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] 2gig limit sticking into bash shell That is an interesting one!? So the file system, kernel, version of zip, etc are all OK for the 2 gig 32-bit limit, but once you go into 32 bit udt and back out (or from inside) you have the issue.? I am wondering if your library path has changed, or the PATH var itself.? Does anything look different in the environment after launching udt and exiting?? I am wondering if you save the environment and check after, something like: $ set /tmp/envbefore $ udt?? (then exit out) $ set /tmp/envafter $ diff /tmp/envbefore /tmp/envafter (Particularly interested in LD_LIBRARY_PATH) If you run zip with the full path name does it work?? Maybe a
Re: [U2] Simple Export to Excel
Instead of Tab-delimited, look at CSV format. It supports embedded single- and double-quotes. And CSV imports into Excel. Embedded double quotes are two consecutive chars: Tab delimit4ed fiels work the same as comma delimited files as far as how they handle quotes. And Excel will import them. I tend to use tabs to avoid problems with users entering commas in the data which causes problems with columns. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
I second what Charles is saying. When moving data into Excel, tab-sep format is a lot cleaner because you don't have to care whether a field has an embedded comma, squote, or dquote. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2gig limit sticking into bash shell
You may want to check the ulimit for the user. Shell down to Unix and perform a ulimit -f this will tell you if there is a max file size set on this specific user. Dan Goble Sr. Programmer Analyst RATEX Business Solutions, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, July 06, 2009 6:01 AM To: 'U2 Users List' Subject: Re: [U2] 2gig limit sticking into bash shell Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 BGINPUTTIMEOUT=0 BIMG_BUFSZ=102400 BIMG_FLUSH_BLKS=2 BIMG_MIN_BLKS=10 BPF_NFILES=80 10c22,24 COLORS=/etc/DIR_COLORS.xterm --- CENTURY_PIVOT=1930 CHECK_HOLD_EXIST=0 CHKPNT_TIME=300 11a26,27 COMPACTOR_POLICY=1 CONVERT_EURO=0 12a29 EFS_LCKTIME=0 14a32,34 EXPBLKSIZE=16 FCNTL_ON=0 GLM_MEM_SEGSZ=4194304 15a36,37 GRPCMT_TIME=5 GRP_FREE_BLK=5 23c45,46 IFS=$' \t\n' --- IFS=' ' 24a48,49 JRNL_MAX_FILES=400 JRNL_MAX_PROCS=1 25a51,52 KEYDATA_MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 26a54,55 LB_FLAG=1 LCT_NUM=8 29a59 LOCKFIFO=0 34a65,102 MAX_CAPT_LEVEL=2 MAX_DSFILES=1000 MAX_FLENGTH=1073741824 MAX_LRF_FILESIZE=134217728 MAX_NEXT_HOLD_DIGITS=4 MAX_OBJ_SIZE=307200 MAX_OPEN_FILE=500 MAX_OPEN_OSF=100 MAX_OPEN_SEQF=150 MAX_REP_DISTRIB=1 MAX_REP_SHMSZ=33554432 MAX_RETN_LEVEL=2 MERGE_LOAD=40 MGLM_BUCKET_SIZE=50 MIN_MEMORY_TEMP=64 NFA_CONVERT_CHAR=0 NFILES=1019 NSEM_PSET=8 NULL_FLAG=0 NUSERS=40 N_AFT=200 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_AFT_SECTION=1 N_AIMG=2 N_ARCH=2 N_BIG=233 N_BIMG=2 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 N_GLM_SELF_BUCKET=23 N_PARTFILE=500 N_PGQ=10 N_PUT=8192 N_REP_OPEN_FILE=8 N_SYNC=0 N_TMAFT_BUCKET=19 N_TMQ=10 39a108 PART_TBL=/usr/ud71/parttbl 41,44c110,113 PIPESTATUS=([0]=0) PPID=7616 PROMPT_COMMAND='echo -ne \033]0;${us...@${hostname%%.*}:${PWD/#$HOME/~}\007' PS1='[...@\h \W]\$ ' --- PIPESTATUS=([0]=0 [1]=2) POSIXLY_CORRECT=y PPID=10236 PS1='\s-\v\$ ' 47c116,122 PWD=/home/symeon --- PWD=/usr/ud/accounts/cust855 REP_FLAG=0 REP_LOG_PATH=/usr/ud71/replog SBCS_SHM_SIZE=1048576 SB_FLAG=0 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 49,50c124,140 SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor SHLVL=1 --- SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor:posix SHLVL=3 SHM_ATT_ADD=0 SHM_FIL_CNT=2048 SHM_FREEPCT=25 SHM_GNPAGES=32 SHM_GNTBLS=40 SHM_GPAGESZ=131072 SHM_LBA=4096 SHM_LCINENTS=100 SHM_LMINENTS=32 SHM_LPAGESZ=4096 SHM_LPINENTS=10 SHM_MAX_SIZE=33554432 SHM_MIN_NATT=4 SHM_NFREES=1 SPLIT_LOAD=60 52,55c142,151 SSH_CLIENT=':::87.115.26.230 3539 22' SSH_CONNECTION=':::87.115.26.230 3539 :::78.109.174.173 22' SSH_TTY=/dev/pts/6 SUPPORTED=zh_CN.UTF-8:zh_CN:zh:fr_FR.UTF-8:fr_FR:fr:de_DE.UTF-8:de_DE:de:ja_ JP.UTF-8:ja_JP:ja:es_ES.UTF-8:es_ES:es:en_US.UTF-8:en_US:en --- SSH_CLIENT=':::87.115.26.230 4408 22' SSH_CONNECTION=':::87.115.26.230 4408 :::78.109.174.173 22' SSH_TTY=/dev/pts/7 STATIC_GROWTH_WARN_INTERVAL=300 STATIC_GROWTH_WARN_SIZE=1610612736 STATIC_GROWTH_WARN_TABLE_SIZE=256 SYNC_TIME=0 SYSTEM_EURO=164 SYS_PV=3 TCA_SIZE=128 56a153,157 TERM_EURO=164 TMP=/tmp/ TOGGLE_NAP_TIME=31 TSTIMEOUT=60 UDR_CONVERT_CHAR=1 58a160 UDT_LANGGRP=255/192/129 59a162 UPL_LOGGING=0 61,69c164,167 _=AD psc () { ps --cols=1000 --sort='-%cpu,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } psm () { ps --cols=1000 --sort='-vsz,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } --- VARMEM_PCT=50 WRITE_TO_CONSOLE=0 ZERO_CHAR=131 _= LD_LIBRARY_PATH and PATH are the same all the time. Running unzip with the full path is the same, and whereis unzip only reports the one path of /usr/bin/unzip Also the at command works ! ? I can work with the at command and make it write a completed message at the end and poll for this from the udt process. A strange one tho . Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of regalit...@aol.com Sent: 03 July 2009 16:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] 2gig limit sticking into bash shell That is an interesting one!? So the file system, kernel, version of zip, etc are all OK for the 2 gig 32-bit limit, but once you go into 32 bit udt and back out (or
Re: [U2] Simple Export to Excel
I agree completely. However, Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if you have valid data like 123, 0123 00123. Excel will make then all 123. Sure, I can put quotes around them, but when the folks that use macros and pivot tables, or tie into other Excel files, these will not work (00123 does not equal 0123 in Excel). Big numbers, like GL#s get converted to scientific notation. Some numbers or text get converted to dates. Argh!!! John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, July 06, 2009 9:58 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel I second what Charles is saying. When moving data into Excel, tab-sep format is a lot cleaner because you don't have to care whether a field has an embedded comma, squote, or dquote. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
I like the = method, =1234567890,=001234,=01234,=1234 Will cause the import to treat as literalswhich might be a downside. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, July 06, 2009 10:15 AM To: 'U2 Users List' Subject: Re: [U2] Simple Export to Excel I agree completely. However, Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if you have valid data like 123, 0123 00123. Excel will make then all 123. Sure, I can put quotes around them, but when the folks that use macros and pivot tables, or tie into other Excel files, these will not work (00123 does not equal 0123 in Excel). Big numbers, like GL#s get converted to scientific notation. Some numbers or text get converted to dates. Argh!!! is it talk like pirate day again already? John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
The problem is, Excel actually stores it with the equals and quotes. At a glance, it looks good, but again, it can cause some grief with pivot tables and when bounced against other Excel worksheets that have true data. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 06, 2009 10:35 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel I like the = method, =1234567890,=001234,=01234,=1234 Will cause the import to treat as literalswhich might be a downside. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, July 06, 2009 10:15 AM To: 'U2 Users List' Subject: Re: [U2] Simple Export to Excel I agree completely. However, Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if you have valid data like 123, 0123 00123. Excel will make then all 123. Sure, I can put quotes around them, but when the folks that use macros and pivot tables, or tie into other Excel files, these will not work (00123 does not equal 0123 in Excel). Big numbers, like GL#s get converted to scientific notation. Some numbers or text get converted to dates. Argh!!! is it talk like pirate day again already? John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2gig limit sticking into bash shell
Yes that is the one - ulimit -f is unlimited but when i shell out of udt it is set to 2gig, so i just need to reset this in my command So from tcl i have !ulimit -f unlimited;unzip UPLOAD/000855.zip And this works ! :) Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: 06 July 2009 14:59 To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell You may want to check the ulimit for the user. Shell down to Unix and perform a ulimit -f this will tell you if there is a max file size set on this specific user. Dan Goble Sr. Programmer Analyst RATEX Business Solutions, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, July 06, 2009 6:01 AM To: 'U2 Users List' Subject: Re: [U2] 2gig limit sticking into bash shell Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 BGINPUTTIMEOUT=0 BIMG_BUFSZ=102400 BIMG_FLUSH_BLKS=2 BIMG_MIN_BLKS=10 BPF_NFILES=80 10c22,24 COLORS=/etc/DIR_COLORS.xterm --- CENTURY_PIVOT=1930 CHECK_HOLD_EXIST=0 CHKPNT_TIME=300 11a26,27 COMPACTOR_POLICY=1 CONVERT_EURO=0 12a29 EFS_LCKTIME=0 14a32,34 EXPBLKSIZE=16 FCNTL_ON=0 GLM_MEM_SEGSZ=4194304 15a36,37 GRPCMT_TIME=5 GRP_FREE_BLK=5 23c45,46 IFS=$' \t\n' --- IFS=' ' 24a48,49 JRNL_MAX_FILES=400 JRNL_MAX_PROCS=1 25a51,52 KEYDATA_MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 26a54,55 LB_FLAG=1 LCT_NUM=8 29a59 LOCKFIFO=0 34a65,102 MAX_CAPT_LEVEL=2 MAX_DSFILES=1000 MAX_FLENGTH=1073741824 MAX_LRF_FILESIZE=134217728 MAX_NEXT_HOLD_DIGITS=4 MAX_OBJ_SIZE=307200 MAX_OPEN_FILE=500 MAX_OPEN_OSF=100 MAX_OPEN_SEQF=150 MAX_REP_DISTRIB=1 MAX_REP_SHMSZ=33554432 MAX_RETN_LEVEL=2 MERGE_LOAD=40 MGLM_BUCKET_SIZE=50 MIN_MEMORY_TEMP=64 NFA_CONVERT_CHAR=0 NFILES=1019 NSEM_PSET=8 NULL_FLAG=0 NUSERS=40 N_AFT=200 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_AFT_SECTION=1 N_AIMG=2 N_ARCH=2 N_BIG=233 N_BIMG=2 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 N_GLM_SELF_BUCKET=23 N_PARTFILE=500 N_PGQ=10 N_PUT=8192 N_REP_OPEN_FILE=8 N_SYNC=0 N_TMAFT_BUCKET=19 N_TMQ=10 39a108 PART_TBL=/usr/ud71/parttbl 41,44c110,113 PIPESTATUS=([0]=0) PPID=7616 PROMPT_COMMAND='echo -ne \033]0;${us...@${hostname%%.*}:${PWD/#$HOME/~}\007' PS1='[...@\h \W]\$ ' --- PIPESTATUS=([0]=0 [1]=2) POSIXLY_CORRECT=y PPID=10236 PS1='\s-\v\$ ' 47c116,122 PWD=/home/symeon --- PWD=/usr/ud/accounts/cust855 REP_FLAG=0 REP_LOG_PATH=/usr/ud71/replog SBCS_SHM_SIZE=1048576 SB_FLAG=0 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 49,50c124,140 SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor SHLVL=1 --- SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor:posix SHLVL=3 SHM_ATT_ADD=0 SHM_FIL_CNT=2048 SHM_FREEPCT=25 SHM_GNPAGES=32 SHM_GNTBLS=40 SHM_GPAGESZ=131072 SHM_LBA=4096 SHM_LCINENTS=100 SHM_LMINENTS=32 SHM_LPAGESZ=4096 SHM_LPINENTS=10 SHM_MAX_SIZE=33554432 SHM_MIN_NATT=4 SHM_NFREES=1 SPLIT_LOAD=60 52,55c142,151 SSH_CLIENT=':::87.115.26.230 3539 22' SSH_CONNECTION=':::87.115.26.230 3539 :::78.109.174.173 22' SSH_TTY=/dev/pts/6 SUPPORTED=zh_CN.UTF-8:zh_CN:zh:fr_FR.UTF-8:fr_FR:fr:de_DE.UTF-8:de_DE:de:ja_ JP.UTF-8:ja_JP:ja:es_ES.UTF-8:es_ES:es:en_US.UTF-8:en_US:en --- SSH_CLIENT=':::87.115.26.230 4408 22' SSH_CONNECTION=':::87.115.26.230 4408 :::78.109.174.173 22' SSH_TTY=/dev/pts/7 STATIC_GROWTH_WARN_INTERVAL=300 STATIC_GROWTH_WARN_SIZE=1610612736 STATIC_GROWTH_WARN_TABLE_SIZE=256 SYNC_TIME=0 SYSTEM_EURO=164 SYS_PV=3 TCA_SIZE=128 56a153,157 TERM_EURO=164 TMP=/tmp/ TOGGLE_NAP_TIME=31 TSTIMEOUT=60 UDR_CONVERT_CHAR=1 58a160 UDT_LANGGRP=255/192/129 59a162 UPL_LOGGING=0 61,69c164,167 _=AD psc () { ps --cols=1000 --sort='-%cpu,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } psm () { ps --cols=1000 --sort='-vsz,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } --- VARMEM_PCT=50 WRITE_TO_CONSOLE=0 ZERO_CHAR=131 _= LD_LIBRARY_PATH and PATH are the same all the time. Running unzip with the full path is the same, and whereis unzip only reports the one path of /usr/bin/unzip Also the at command works ! ? I can work with the at command and make it write a completed message at the end and poll for this from the udt process.
Re: [U2] Simple Export to Excel
Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if you have valid data like 123, 0123 00123. Excel will make then all 123. I agree. You can quote text values, but this is problematic if the data itself contained quotes. It helps some if you define the fields as text instead of general in the import screen. But there are still problems. I have tried to convince users not to overuse Excel, but they usually act like I just ran over their favorite puppy. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
The problem with Excel stripping leading zeroes and converting stuff to dates can be completely mitigated if you download and open the sheet manually. If you open the sheet automatically, Excel does its magic. However, if you open a .txt file with tabs (or even commas for that matter) you can then decide what each column should be. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
Or, you can create your export in the Office XML format, and tell excel explicitly what to do with each column of data. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, July 06, 2009 8:34 AM To: U2 Users List Subject: Re: [U2] Simple Export to Excel The problem with Excel stripping leading zeroes and converting stuff to dates can be completely mitigated if you download and open the sheet manually. If you open the sheet automatically, Excel does its magic. However, if you open a .txt file with tabs (or even commas for that matter) you can then decide what each column should be. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com wrote: Or, you can create your export in the Office XML format, and tell excel explicitly what to do with each column of data. Absolutely. But what a time-consuming chore that can be... :-) -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
ad (actually endorsement from happy user) Which is why Tony G's NebulaXlite exists. /ad On Mon, Jul 6, 2009 at 9:54 AM, Kevin King precisonl...@gmail.com wrote: On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com wrote: Or, you can create your export in the Office XML format, and tell excel explicitly what to do with each column of data. Absolutely. But what a time-consuming chore that can be... :-) -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
The solutions provided here should help: nospamNebula-RnD.com/blog/tech/2009/07/excel-csv1.html From: John Israel ...Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if you have valid data like 123, 0123 00123. Excel will make then all 123. Sure, I can put quotes around them, but when the folks that use macros and pivot tables, or tie into other Excel files, these will not work (00123 does not equal 0123 in Excel). Big numbers, like GL#s get converted to scientific notation. Some numbers or text get converted to dates. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2gig limit sticking into bash shell
Symeon: Would you consider this a bug? I wonder if the same problem exists on Windows? Bill Symeon Breen said the following on 7/6/2009 8:07 AM: Yes that is the one - ulimit -f is unlimited but when i shell out of udt it is set to 2gig, so i just need to reset this in my command So from tcl i have !ulimit -f unlimited;unzip UPLOAD/000855.zip And this works ! :) Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: 06 July 2009 14:59 To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell You may want to check the ulimit for the user. Shell down to Unix and perform a ulimit -f this will tell you if there is a max file size set on this specific user. Dan Goble Sr. Programmer Analyst RATEX Business Solutions, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, July 06, 2009 6:01 AM To: 'U2 Users List' Subject: Re: [U2] 2gig limit sticking into bash shell Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 BGINPUTTIMEOUT=0 BIMG_BUFSZ=102400 BIMG_FLUSH_BLKS=2 BIMG_MIN_BLKS=10 BPF_NFILES=80 10c22,24 COLORS=/etc/DIR_COLORS.xterm --- CENTURY_PIVOT=1930 CHECK_HOLD_EXIST=0 CHKPNT_TIME=300 11a26,27 COMPACTOR_POLICY=1 CONVERT_EURO=0 12a29 EFS_LCKTIME=0 14a32,34 EXPBLKSIZE=16 FCNTL_ON=0 GLM_MEM_SEGSZ=4194304 15a36,37 GRPCMT_TIME=5 GRP_FREE_BLK=5 23c45,46 IFS=$' \t\n' --- IFS=' ' 24a48,49 JRNL_MAX_FILES=400 JRNL_MAX_PROCS=1 25a51,52 KEYDATA_MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 26a54,55 LB_FLAG=1 LCT_NUM=8 29a59 LOCKFIFO=0 34a65,102 MAX_CAPT_LEVEL=2 MAX_DSFILES=1000 MAX_FLENGTH=1073741824 MAX_LRF_FILESIZE=134217728 MAX_NEXT_HOLD_DIGITS=4 MAX_OBJ_SIZE=307200 MAX_OPEN_FILE=500 MAX_OPEN_OSF=100 MAX_OPEN_SEQF=150 MAX_REP_DISTRIB=1 MAX_REP_SHMSZ=33554432 MAX_RETN_LEVEL=2 MERGE_LOAD=40 MGLM_BUCKET_SIZE=50 MIN_MEMORY_TEMP=64 NFA_CONVERT_CHAR=0 NFILES=1019 NSEM_PSET=8 NULL_FLAG=0 NUSERS=40 N_AFT=200 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_AFT_SECTION=1 N_AIMG=2 N_ARCH=2 N_BIG=233 N_BIMG=2 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 N_GLM_SELF_BUCKET=23 N_PARTFILE=500 N_PGQ=10 N_PUT=8192 N_REP_OPEN_FILE=8 N_SYNC=0 N_TMAFT_BUCKET=19 N_TMQ=10 39a108 PART_TBL=/usr/ud71/parttbl 41,44c110,113 PIPESTATUS=([0]=0) PPID=7616 PROMPT_COMMAND='echo -ne \033]0;${us...@${hostname%%.*}:${PWD/#$HOME/~}\007' PS1='[...@\h \W]\$ ' --- PIPESTATUS=([0]=0 [1]=2) POSIXLY_CORRECT=y PPID=10236 PS1='\s-\v\$ ' 47c116,122 PWD=/home/symeon --- PWD=/usr/ud/accounts/cust855 REP_FLAG=0 REP_LOG_PATH=/usr/ud71/replog SBCS_SHM_SIZE=1048576 SB_FLAG=0 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 49,50c124,140 SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor SHLVL=1 --- SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive-comments: monitor:posix SHLVL=3 SHM_ATT_ADD=0 SHM_FIL_CNT=2048 SHM_FREEPCT=25 SHM_GNPAGES=32 SHM_GNTBLS=40 SHM_GPAGESZ=131072 SHM_LBA=4096 SHM_LCINENTS=100 SHM_LMINENTS=32 SHM_LPAGESZ=4096 SHM_LPINENTS=10 SHM_MAX_SIZE=33554432 SHM_MIN_NATT=4 SHM_NFREES=1 SPLIT_LOAD=60 52,55c142,151 SSH_CLIENT=':::87.115.26.230 3539 22' SSH_CONNECTION=':::87.115.26.230 3539 :::78.109.174.173 22' SSH_TTY=/dev/pts/6 SUPPORTED=zh_CN.UTF-8:zh_CN:zh:fr_FR.UTF-8:fr_FR:fr:de_DE.UTF-8:de_DE:de:ja_ JP.UTF-8:ja_JP:ja:es_ES.UTF-8:es_ES:es:en_US.UTF-8:en_US:en --- SSH_CLIENT=':::87.115.26.230 4408 22' SSH_CONNECTION=':::87.115.26.230 4408 :::78.109.174.173 22' SSH_TTY=/dev/pts/7 STATIC_GROWTH_WARN_INTERVAL=300 STATIC_GROWTH_WARN_SIZE=1610612736 STATIC_GROWTH_WARN_TABLE_SIZE=256 SYNC_TIME=0 SYSTEM_EURO=164 SYS_PV=3 TCA_SIZE=128 56a153,157 TERM_EURO=164 TMP=/tmp/ TOGGLE_NAP_TIME=31 TSTIMEOUT=60 UDR_CONVERT_CHAR=1 58a160 UDT_LANGGRP=255/192/129 59a162 UPL_LOGGING=0 61,69c164,167 _=AD psc () { ps --cols=1000 --sort='-%cpu,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } psm () { ps --cols=1000 --sort='-vsz,uid,pgid,ppid,pid' -e -o user,pid,ppid,pgid,stime,stat,wchan,time,pcpu,pmem,vsz,rss,sz,args | sed 's/^/ /' | less } --- VARMEM_PCT=50 WRITE_TO_CONSOLE=0 ZERO_CHAR=131 _= LD_LIBRARY_PATH and PATH are the same all the time.
Re: [U2] 2gig limit sticking into bash shell
Bill Haskett wrote: Symeon: Would you consider this a bug? I wonder if the same problem exists on Windows? Bill Symeon Breen said the following on 7/6/2009 8:07 AM: -Original Message- From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jul 3, 2009 7:07 am Subject: [U2] 2gig limit sticking into bash shell Hi, Redhat linux ES 3 64bit with udt 7.1 32 bit - i have a zip file that contains a 12 gig csv in it. I can unzip this fine from bash. However if i go into udt then either shell out, or quit from udt and try the unzip command it stops when the extract gets to 2gig. I understand the fork-exec mechanism of *nix, so i wondered is there a particular environment variable or something else that i can change in the new shell so that my unzip command will work ! Thanks. Symeon. Is the ulimit a rhel command? I think it is, so it wouldn't be a unidata bug, per se. While you're tackling this, I did some comparisons the other day with zip vs 7z vs bzip. 7z is freely available for win and *nix, and on my 64-bit Core2duo server, it made use of both processor cores (which the other two did not.) 7z took a 1G vmdk down to ~260M with teh default options. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 2gig limit sticking into bash shell
I'm on UV 10.0.2 on Redhat, I did a shell, and my ulimit was unlimited. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, July 06, 2009 1:57 PM To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell Symeon: Would you consider this a bug? I wonder if the same problem exists on Windows? Bill Symeon Breen said the following on 7/6/2009 8:07 AM: Yes that is the one - ulimit -f is unlimited but when i shell out of udt it is set to 2gig, so i just need to reset this in my command So from tcl i have !ulimit -f unlimited;unzip UPLOAD/000855.zip And this works ! :) Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: 06 July 2009 14:59 To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell You may want to check the ulimit for the user. Shell down to Unix and perform a ulimit -f this will tell you if there is a max file size set on this specific user. Dan Goble Sr. Programmer Analyst RATEX Business Solutions, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, July 06, 2009 6:01 AM To: 'U2 Users List' Subject: Re: [U2] 2gig limit sticking into bash shell Thanks for the pointers, Sorry i mislead you a bit - when i tried this myself it does indeed work if you come out of udt and run it, it is only if you shell out from within udt that it fails. The set command before and while in udt shows quite a few diffs, these mainly look to be udt config params tho :- diff set.out set2.out 2c2,9 BASH=/bin/bash --- AIMG_BUFSZ=102400 AIMG_FLUSH_BLKS=2 AIMG_MIN_BLKS=10 ARCHIVE_TO_TAPE=0 ARCH_FLAG=0 ARCH_WRITE_SZ=0 AVG_TUPLE_LEN=4 BASH=/bin/sh 8a16,20 BGINPUTTIMEOUT=0 BIMG_BUFSZ=102400 BIMG_FLUSH_BLKS=2 BIMG_MIN_BLKS=10 BPF_NFILES=80 10c22,24 COLORS=/etc/DIR_COLORS.xterm --- CENTURY_PIVOT=1930 CHECK_HOLD_EXIST=0 CHKPNT_TIME=300 11a26,27 COMPACTOR_POLICY=1 CONVERT_EURO=0 12a29 EFS_LCKTIME=0 14a32,34 EXPBLKSIZE=16 FCNTL_ON=0 GLM_MEM_SEGSZ=4194304 15a36,37 GRPCMT_TIME=5 GRP_FREE_BLK=5 23c45,46 IFS=$' \t\n' --- IFS=' ' 24a48,49 JRNL_MAX_FILES=400 JRNL_MAX_PROCS=1 25a51,52 KEYDATA_MERGE_LOAD=40 KEYDATA_SPLIT_LOAD=95 26a54,55 LB_FLAG=1 LCT_NUM=8 29a59 LOCKFIFO=0 34a65,102 MAX_CAPT_LEVEL=2 MAX_DSFILES=1000 MAX_FLENGTH=1073741824 MAX_LRF_FILESIZE=134217728 MAX_NEXT_HOLD_DIGITS=4 MAX_OBJ_SIZE=307200 MAX_OPEN_FILE=500 MAX_OPEN_OSF=100 MAX_OPEN_SEQF=150 MAX_REP_DISTRIB=1 MAX_REP_SHMSZ=33554432 MAX_RETN_LEVEL=2 MERGE_LOAD=40 MGLM_BUCKET_SIZE=50 MIN_MEMORY_TEMP=64 NFA_CONVERT_CHAR=0 NFILES=1019 NSEM_PSET=8 NULL_FLAG=0 NUSERS=40 N_AFT=200 N_AFT_BUCKET=101 N_AFT_MLF_BUCKET=23 N_AFT_SECTION=1 N_AIMG=2 N_ARCH=2 N_BIG=233 N_BIMG=2 N_FILESYS=200 N_GLM_GLOBAL_BUCKET=101 N_GLM_SELF_BUCKET=23 N_PARTFILE=500 N_PGQ=10 N_PUT=8192 N_REP_OPEN_FILE=8 N_SYNC=0 N_TMAFT_BUCKET=19 N_TMQ=10 39a108 PART_TBL=/usr/ud71/parttbl 41,44c110,113 PIPESTATUS=([0]=0) PPID=7616 PROMPT_COMMAND='echo -ne \033]0;${us...@${hostname%%.*}:${PWD/#$HOME/~}\007' PS1='[...@\h \W]\$ ' --- PIPESTATUS=([0]=0 [1]=2) POSIXLY_CORRECT=y PPID=10236 PS1='\s-\v\$ ' 47c116,122 PWD=/home/symeon --- PWD=/usr/ud/accounts/cust855 REP_FLAG=0 REP_LOG_PATH=/usr/ud71/replog SBCS_SHM_SIZE=1048576 SB_FLAG=0 SETINDEX_BUFFER_KEYS=0 SETINDEX_VALIDATE_KEY=0 49,50c124,140 SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive- comments: monitor SHLVL=1 --- SHELLOPTS=braceexpand:emacs:hashall:histexpand:history:interactive- comments: monitor:posix SHLVL=3 SHM_ATT_ADD=0 SHM_FIL_CNT=2048 SHM_FREEPCT=25 SHM_GNPAGES=32 SHM_GNTBLS=40 SHM_GPAGESZ=131072 SHM_LBA=4096 SHM_LCINENTS=100 SHM_LMINENTS=32 SHM_LPAGESZ=4096 SHM_LPINENTS=10 SHM_MAX_SIZE=33554432 SHM_MIN_NATT=4 SHM_NFREES=1 SPLIT_LOAD=60 52,55c142,151 SSH_CLIENT=':::87.115.26.230 3539 22' SSH_CONNECTION=':::87.115.26.230 3539 :::78.109.174.173 22' SSH_TTY=/dev/pts/6 SUPPORTED=zh_CN.UTF-8:zh_CN:zh:fr_FR.UTF-8:fr_FR:fr:de_DE.UTF- 8:de_DE:de:ja_ JP.UTF-8:ja_JP:ja:es_ES.UTF-8:es_ES:es:en_US.UTF-8:en_US:en --- SSH_CLIENT=':::87.115.26.230 4408 22' SSH_CONNECTION=':::87.115.26.230 4408 :::78.109.174.173 22' SSH_TTY=/dev/pts/7 STATIC_GROWTH_WARN_INTERVAL=300 STATIC_GROWTH_WARN_SIZE=1610612736 STATIC_GROWTH_WARN_TABLE_SIZE=256 SYNC_TIME=0 SYSTEM_EURO=164 SYS_PV=3 TCA_SIZE=128
Re: [U2] 2gig limit sticking into bash shell
Not sure it is a bug TBH , i presume the shell is inheriting the settings from the udt shell above it. If at bash i do ulimit -f 1000 Then do another shell (type sh) and do ulimit -f it says 1000 so ulimit does seem to be inherited. Ofcourse udt is changing it from its parent shell i assume because it is the 32 bit version. Now I know about this it is fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 06 July 2009 18:58 To: U2 Users List Subject: Re: [U2] 2gig limit sticking into bash shell Symeon: Would you consider this a bug? I wonder if the same problem exists on Windows? Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
I have a little ODBC project that I just started. Getting the IBM-U2 ODBC Driver to work with Excel was almost painless. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
Group (I didn't see who the OP was), I have a perl script/unidata program which will do XLS (Excel 2003 and before). It requires that perl be installed and a few *excel.ppms* freely available. The black box unidata driver program handles column heading, formatting, justification, sorting, subtotaling and grouping. I'm working through the OpenXML formats for Office, I've conquered Word 2007 and moving onto Excel 2007 (openxml) next. I will update the group when I finish. If anyone wants the perl/excel2003 scripts and unidata programs let me know. (email: u2ex...@remove-thissoutheast-florida.com) south east (dash) florida dot com Don Verhagen (Plugging along in SQL and .Net where a simple generic empty validation ain't so simple!) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, July 06, 2009 12:55 PM To: U2 Users List Subject: Re: [U2] Simple Export to Excel On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com wrote: Or, you can create your export in the Office XML format, and tell excel explicitly what to do with each column of data. Absolutely. But what a time-consuming chore that can be... :-) -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unknown Error [39202] Slave failed to give server the Go Ahead message
I try to use UODOTNET OpenSecureSession method to open a SSL secure session. I use self-sign certificate and get the following error message: IBM U2UODOTNET - UNICLIENTErrorCode=39202 Unknown Error 39202 Occurred at IBMU2.UODOTNET.UniObjects.OpenSecureSession(String hostname, Int32 port, String userid, String password, String account, String service, X509Certificate clientcertificate) I found 39202 indicate Slave failed to give server the Go Ahead message. But I have no idea what causes this problem and how to fix it. in the UOListener.log file, I get the follow records: 7/07/2009 12:06:57 PM:ThreadID: 1 Name : UniObjects::OpenSecureSession() hostname : 17.17.11.11 port : 31438 User : root Password : password Account : /usr/test/data/account1 Service : udcs 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniSession::UniSession() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniRPCConnection::UniRPCConnection() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniRPCPacket::UniRPCPacket() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniRPCPMessage::UniRPCPMessage() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCPMessage::UniRPCPMessage() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCPacket::UniRPCPacket() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniRPCPacket::UniRPCPacket() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniRPCPMessage::UniRPCPMessage() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCPMessage::UniRPCPMessage() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCPacket::UniRPCPacket() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCConnection::UniRPCConnection() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniSession::UniSession() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniSession::Connect() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniRPCConnection::ConnectInternalSSL(int responseIndex,X509Certificate clientcertificate)0 7/07/2009 12:06:57 PM:ThreadID: 1 Name : UniRPCConnection::ConnectInternalSSL()m_InPacket.UniRPCPMessage.ArgumentCount is 2 7/07/2009 12:06:57 PM:ThreadID: 1 Name : UniRPCConnection::ConnectInternalSSL()response is 0 7/07/2009 12:06:57 PM:ThreadID: 1 Name : In UniRPCConnection::SelectLocalCertificate() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCConnection::SelectLocalCertificate() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : In UniRPCConnection::SelectLocalCertificate() returned certificate: 7/07/2009 12:06:57 PM:ThreadID: 1 Name : In UniRPCConnection::ValidateServerCertificate() sslPolicyErrors:None 7/07/2009 12:06:57 PM:ThreadID: 1 Name : In UniRPCConnection::ValidateServerCertificate() certificate:Subject e=em...@gmail.com, CN=17.17.11.11, OU=test, O=test, L=test, S=test, C=AU Issuer e=em...@gmail.com, CN=17.17.11.11, OU=test, O=test, L=test, S=test, C=AU Serial Number 00FA000ADAC056 Not Before 6/07/2009 3:45:24 PM Not After 6/07/2010 3:45:24 PM Thumbprint 6E3A4B1A3FA27E28FD530BE8E0FDE00F 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCConnection::ValidateServerCertificate() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniRPCConnection::ConnectInternalSSL(int responseIndex) 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Enter UniSession::Encrypt() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Exit UniSession::Encrypt() 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Get Property UniSession::IPAddress HostName is mel007 7/07/2009 12:06:57 PM:ThreadID: 1 Name : Get Property UniSession::IPAddress IPAddress is -1408039802 7/07/2009 12:06:57 PM:ThreadID: 1 Name : IBM U2UODOTNET - UNICLIENTErrorCode=39202 Unknown Error 39202 Occurred Source: UniSession Class Method: void Connect() I get the following log in unidata server: udapi_server using /usr/unidata/ud72/bin/udapi_slave to launch slave. udapi_server setting SO_KEEPALIVE done. api_server running in /usr/unidata/ud72/bin, debugLevel=9 ssl flag: 1 ssl server: udcs SSLbinding: OK server login name=root. udapi_server pipe_read 1 byte_count=0. udapi_server exit wait for slave 331902 to go away. udapi_server exit connect_number=1. Thanks in advance -- View this message in context: http://www.nabble.com/Unknown-Error--39202--Slave-failed-to-give-server-the-Go-Ahead-message-tp24366224p24366224.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniVerse configuration options SCRMIN, SCRMAX and SCRSIZE
Hello all. I have been working through some performance issues with a customer of ours, and naturally have been looking at what changes are possible in the UniVerse configuration. At present I am looking to better understand the SCRMIN, SCRMAX and SCRSIZE parameters. I understand these parameters to influence the scratch buffer pool for UniVerse (apparently used for temporary storage in an attempt to minimise calls to 'malloc' and 'free' during execution). What I do not yet understand is under what circumstances would changing these parameters be of benefit. Has anyone encountered a situation where the SCRMIN, SCRMAX and SCRSIZE parameters were adjusted? What where the conditions that lead to the change, and what was the impact of the changes on performance? Thanks Gregor Scott ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users