Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates
IDS 11.10 - 30 Sep 2012
Subscribe to notifications

IIUG on Facebook IIUG on Twitter

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

Re: Physical Log Size

Posted By: Mirav Kapadia
Date: Tuesday, 25 January 2011, at 2:21 p.m.

In Response To: Physical Log Size (KENT GRUNDEN)

Since, you have updated the size in onconfig file, probably you are mis=
sing
complete disk initialization (-i).

Another option - you could change the physical log size/location in onl=
ine
mode with onparams/SQL Admin API "alter plog".

Regards,

-- Mirav

Mirav Kapadia (mirav@us.ibm.com)
Informix Embed, Virtualization & Cloud
Computing Team
Phone: +1 (913) 599-8456 | Tieline:
337-8456

From: "KENT GRUNDEN" <k.grunden@hoogwegtus.com>
To: ids@iiug.org
Date: 01/25/2011 01:12 PM
Subject: Physical Log Size [22556]
Sent by: ids-bounces@iiug.org

IDS 11.50.FC4WE Windows Server 2008 64bit

I keep getting the message when I restart the Informix instance that th=
e
physical log file might be too small. It recommends 28000.
I increased the PHYSFILE from 15000 all the way up to 800000, but I am
still
getting this message in the log. (I did this in increments but am afrai=
d to
go
too far)
What am I missing?
Thanks

Log file
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Tue Jan 25 12:51:02 2011

12:51:02 Warning: ONCONFIG dump directory (DUMPDIR)
'D:\PROGRA~1\IBM\IBMINF~1\11.50\tmp' has insecure permissions
12:51:02 Booting Language <c> from module <>
12:51:02 Loading Module <CNULL>
12:51:02 Booting Language <builtin> from module <>
12:51:02 Loading Module <BUILTINNULL>
12:51:02 Could not disable priority aging: errno =3D 0
12:51:02 Affinitied VP 1 to phys proc 1
12:51:03 Could not disable priority aging: errno =3D 0
12:51:03 Affinitied VP 3 to phys proc 2
12:51:03 Could not disable priority aging: errno =3D 0
12:51:03 Affinitied VP 4 to phys proc 3
12:51:04 Could not disable priority aging: errno =3D 0
12:51:04 Affinitied VP 5 to phys proc 4
12:51:07 DR: DRAUTO is 0 (Off)
12:51:07 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
12:51:07 IBM Informix Dynamic Server Version 11.50.FC4WE Software Seria=
l
Number AAA#B000000
12:51:08 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.

12:51:08 Started 1 B-tree scanners.
12:51:09 B-tree scanner threshold set at 5000.
12:51:09 B-tree scanner range scan size set to -1.
12:51:09 B-tree scanner ALICE mode set to 6.
12:51:09 B-tree scanner index compression level set to med.
12:51:09 Physical Recovery Started at Page (1:2127).
12:51:09 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored=
.
12:51:09 Logical Recovery Started.
12:51:09 10 recovery worker threads will be started.
12:51:10 Logical Recovery has reached the transaction cleanup phase.
12:51:10 Logical Recovery Complete.

0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

12:51:11 Dataskip is now OFF for all dbspaces
12:51:12 Init operation complete - Mode Online
12:51:13 Checkpoint Completed: duration was 1 seconds.
12:51:14 Tue Jan 25 - loguniq 34022, logpos 0xaa018, timestamp: 0x2b38d=
818
Interval: 63728

12:51:14 Maximum server connections 0
12:51:14 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns bloc=
ked
0,
Plog used 2, Llog used 1

12:51:14 On-Line Mode
12:51:14 SCHAPI: Started dbScheduler thread.
12:51:15 Booting Language <spl> from module <>
12:51:15 Loading Module <SPLNULL>
12:51:15 SCHAPI: Started 2 dbWorker threads.
12:51:17 Performance Advisory: Based on the current workload, the physi=
cal
log
might be too small to
accommodate the time it takes to flush the buffer pool.
12:51:18 Results: The server might block transactions during checkpoint=
s.
12:51:18 Action: If transactions are blocked during the checkpoint,
increase
the size of the
physical log to at least 28000 KB.
12:51:18 Performance Advisory: The physical log is too small for automa=
tic
checkpoints.
12:51:18 Results: Automatic checkpoints are disabled.
12:51:18 Action: To enable automatic checkpoints, increase the physical=
log
to
at least 28000 KB.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

ONCONFIG file
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

ROOTNAME rootdbs
ROOTPATH D:\IFMXDATA\ol_shustest\rootdbs_dat.000 # Path for device
containing
root dbspace
ROOTOFFSET 0
ROOTSIZE 204800 # Size of root dbspace (Kbytes)
MIRROR 0 # Mirroring flag (Yes =3D 1, No =3D 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0

PHYSFILE 800000 #was 15000
PLOG_OVERFLOW_PATH
PHYSBUFF 128

LOGFILES 22
LOGSIZE 5000
DYNAMIC_LOGS 2
LOGBUFF 64

LTXHWM 70
LTXEHWM 80

MSGPATH D:\PROGRA~1\IBM\IBMINF~1\11.50\ol_shustest.log # System message=
log

file path
CONSOLE D:\PROGRA~1\IBM\IBMINF~1\11.50\conol_shustest.log # System cons=
ole
message path

TBLTBLFIRST 0
TBLTBLNEXT 0
TBLSPACE_STATS 1

DBSPACETEMP
SBSPACETEMP

SBSPACENAME sbspace # Default sbspace
SYSSBSPACENAME sbspace # Default System sbspace
ONDBSPACEDOWN 2

SERVERNUM 0 # Unique id corresponding to a server instance
DBSERVERNAME ol_shustest # Name of default Dynamic Server
DBSERVERALIASES # List of alternate dbserver names

NETTYPE
LISTEN_TIMEOUT 60
MAX_INCOMPLETE_CONNECTIONS 1024
FASTPOLL 1

MULTIPROCESSOR 1
VPCLASS cpu,num=3D15,noage
VP_MEMORY_CACHE_KB 0
SINGLE_CPU_VP 0

#VPCLASS aio,num=3D1
CLEANERS 8
AUTO_AIOVPS 1
DIRECT_IO 0

LOCKS 200000
DEF_TABLE_LOCKMODE page

RESIDENT 0
SHMBASE 0x80000000L
SHMVIRTSIZE 120704 #was 3017
SHMADD 120704
EXTSHMADD 8192
SHMTOTAL 0
SHMVIRT_ALLOCSEG 0,3
#SHMNOACCESS 0x70000000-0x7FFFFFFF

CKPTINTVL 300
AUTO_CKPTS 1
RTO_SERVER_RESTART 0
BLOCKTIMEOUT 3600

TXTIMEOUT 300
DEADLOCK_TIMEOUT 60
HETERO_COMMIT 0

TAPEDEV NUL # \\.\TAPE0
TAPEBLK 16
TAPESIZE 0

LTAPEDEV NUL
LTAPEBLK 16
LTAPESIZE 0

BAR_ACT_LOG D:\PROGRA~1\IBM\IBMINF~1\11.50\bar_ol_shustest.log #Path of=
log

file for onbar.exe
BAR_DEBUG_LOG D:\PROGRA~1\IBM\IBMINF~1\11.50\bar_ol_shustest.log #Path =
of
the
debug log for onbar.exe
BAR_DEBUG 0
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 20
BAR_XFER_BUF_SIZE 15
RESTARTABLE_RESTORE ON
BAR_PROGRESS_FREQ 0
BAR_BSALIB_PATH d:\ISM\2.20\bin\libbsa.dll # Location of ISM XBSA DLL
BACKUP_FILTER
RESTORE_FILTER
BAR_PERFORMANCE 0

ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs

DD_HASHSIZE 31
DD_HASHMAX 10

DS_HASHSIZE 31
DS_POOLSIZE 127

PC_HASHSIZE 31
PC_POOLSIZE 127

STMT_CACHE 0
STMT_CACHE_HITS 0
STMT_CACHE_SIZE 512
STMT_CACHE_NOLIMIT 0
STMT_CACHE_NUMPOOL 1

USEOSTIME 0
STACKSIZE 64
ALLOW_NEWLINE 0
USELASTCOMMITTED NONE

FILLFACTOR 90
MAX_FILL_DATA_PAGES 0
BTSCANNER num=3D1,threshold=3D5000,rangesize=3D-1,alice=3D6,compression=
=3Ddefault
ONLIDX_MAXMEM 5120

MAX_PDQPRIORITY 100
DS_MAX_QUERIES
DS_TOTAL_MEMORY
DS_MAX_SCANS 1048576
DS_NONPDQ_QUERY_MEM 128
DATASKIP

OPTCOMPIND 0
DIRECTIVES 1
EXT_DIRECTIVES 0
OPT_GOAL -1
IFX_FOLDVIEW 0
AUTO_REPREPARE 1

RA_PAGES 128
RA_THRESHOLD 120

EXPLAIN_STAT 1
#SQLTRACE level=3Dlow,ntraces=3D1000,size=3D2,mode=3Dglobal

#DBCREATE_PERMISSION informix
#DB_LIBRARY_PATH
IFX_EXTEND_ROLE 1
SECURITY_LOCALCONNECTION
UNSECURE_ONSTAT
ADMIN_USER_MODE_WITH_DBSA
ADMIN_MODE_USERS
SSL_KEYSTORE_LABEL

PLCY_POOLSIZE 127
PLCY_HASHSIZE 31
USRC_POOLSIZE 127
USRC_HASHSIZE 31

STAGEBLOB
OPCACHEMAX 0

ENCRYPT_HDR
ENCRYPT_SMX
ENCRYPT_CDR 0
ENCRYPT_CIPHERS
ENCRYPT_MAC
ENCRYPT_MACFILE
ENCRYPT_SWITCH

CDR_EVALTHREADS 1,2
CDR_DSLOCKWAIT 5
CDR_QUEUEMEM 4096
CDR_NIFCOMPRESS 0
CDR_SERIAL 0
CDR_DBSPACE
CDR_QHDR_DBSPACE
CDR_QDATA_SBSPACE
CDR_MAX_DYNAMIC_LOGS 0
CDR_SUPPRESS_ATSRISWARN

DRAUTO 0
DRINTERVAL 30
DRTIMEOUT 30
HA_ALIAS
DRLOSTFOUND $INFORMIXDIR\etc\dr.lostfound
DRIDXAUTO 0
LOG_INDEX_BUILDS
SDS_ENABLE
SDS_TIMEOUT 20
SDS_TEMPDBS
SDS_PAGING
UPDATABLE_SECONDARY 0
FAILOVER_CALLBACK
TEMPTAB_NOLOG 0

ON_RECVRY_THREADS 1
OFF_RECVRY_THREADS 10

DUMPDIR D:\PROGRA~1\IBM\IBMINF~1\11.50\tmp # Preserve diagnostics in th=
is
directory
DUMPSHMEM 1
DUMPGCORE 0
DUMPCORE 0
DUMPCNT 1

ALARMPROGRAM D:\PROGRA~1\IBM\IBMINF~1\11.50\etc\alarmprogram.bat # Alar=
m
program path
ALRM_ALL_EVENTS 0
STORAGE_FULL_ALARM 600,3
#SYSALARMPROGRAM $INFORMIXDIR\etc\evidence.bat

RAS_PLOG_SPEED 3750
RAS_LLOG_SPEED 0

EILSEQ_COMPAT_MODE 0

QSTATS 0
WSTATS 0

#VPCLASS jvp,num=3D1
JVPJAVAHOME D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\jre # JDK
installation root directory
JVPHOME D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa # Krakatoa
installation
directory
JVPPROPFILE
D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\.jvpprops_ol_shustest # =
JVP
property file
JVPLOGFILE D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa
\ol_shustest_jvp.log
# VP log file
#JDKVERSION 1.5
JVPJAVALIB \bin
JVPJAVAVM jvm
#JVPARGS -verbose:jni
#JVPCLASSPATH
$INFORMIXDIR\extend\krakatoa\krakatoa_g.jar;$INFORMIXDIR\extend\krakato=
a
\jdbc_g.jar
JVPCLASSPATH
D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa\krakatoa.jar;D:\PROGRA~1=
\IBM
\IBMINF~1\11.50\extend\krakatoa\jdbc.jar

BUFFERPOOL
default,buffers=3D10000,lrus=3D8,lru_min_dirty=3D50.000000,lru_max_dirt=
y=3D60.500000

BUFFERPOOL
size=3D4K,buffers=3D10000,lrus=3D8,lru_min_dirty=3D50.000000,lru_max_di=
rty=3D60.000000

AUTO_LRU_TUNING 1

JVPLOGFILE D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa/jvp.log
JVPLOGFILE D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa/jvp.log
JVPLOGFILE D:\PROGRA~1\IBM\IBMINF~1\11.50\extend\krakatoa/jvp.log

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.