text:
Before you start
About this series
Thinking about seeking certification on System Administration for IBM IDS 11 (Exam 918)? If so, you're in the right spot. This series of eight IDS certification preparation tutorials covers all the basics -- the topics you'll need to understand before you read the first exam question. Even if you're not planning to seek certification right away, this set of tutorials is a great place to start learning what's new in IDS 11.
About this tutorial
Tuning and configuring an IDS database can be a complex process that sometimes overwhelms new DBAs. There are, however, a great number of tools, functions, and applications included with IDS that, once mastered, make this task simple.
This tutorial is designed to introduce you to the set of monitoring tools that are available with IDS 11 and to show you how each is used to monitor how well (or how poorly) your database system is operating. In this tutorial:
- Gain an understanding of how automatic monitoring works
- Learn how administration API enables you to monitor system activity using SQL commands
- Find out how tasks and sensors are created in the scheduler and how data is collected
- Understand how system monitoring interface is used to collect data
- Learn how
oncheckutilities are used to monitor system
- See how the message log is used to diagnose system problems
This tutorial is the second in a series of eight tutorials that can help you prepare for the System Administration for IBM IDS V11 Certification (Exam 918). The material in this tutorial primarily covers the objectives in Section 2 of the test, entitled "System Activity Monitoring."
After completing this tutorial, you should be able to:
- Use automatic monitoring
- Use System-Monitoring Interface
- Use the
- Use the
- Create and modify tasks in the scheduler
- Use operating system commands to monitor
IDS 11 installation is covered in part 1 of this tutorial series. If you haven't already done so, consider downloading and installing a copy of IBM IDS 11. Installing IDS will help you understand many of the concepts that are tested on the System Administration for IBM IDS V11 Certification exam.
System requirements
You do not need a copy of IDS to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM IDS 11 to work along with this tutorial.
Automatic monitoring and corrective actions
You can use the administration API, the scheduler, and information stored in the sysadmin database to manage automatic maintenance, monitoring, and administrative tasks. These components of Dynamic Server enable you to simplify the collection of information and maintenance of the server in complex systems.
Administration API
The SQL administration API enables you to perform remote administration using various, specific SQL commands for tasks such as managing spaces, managing configuration, running routine jobs, and system validation.
You can use
EXECUTE FUNCTION statements to invoke the built-in
admin( ) or
task( ) functions to accomplish administrative tasks that are equivalent to executing various administrative utilities of Dynamic Server.
In the
EXECUTE FUNCTION statements, items in the
argument list specify the utility and its command-line arguments. For example, the
following SQL statement, which is equivalent to the
-ce command, instructs the database server to check the extents:
EXECUTE FUNCTION admin('check extents');
Sysadmin database
The sysadmin database contains tables that store task properties. You use the task properties (not configuration parameters) to define the information that the scheduler collects and the statements that the scheduler runs.
The sysadmin database also contains:
- The built-in
- The built-in
- The command_history table
Table 1. Sysadmin database tables
|Contains information about how and when each task will be executed
|Contains a list of errors, warnings, or information messages that must be monitored
|Contains a list of group names. Each task is a member of a group.
|Lists tasks and contains information about how and when the database server will execute each task
|Contains a list of thresholds that you defined. If a threshold is met, the task can decide to take a different action, such as inserting an alert in the PH_ALERT table.
Each row in the ph_task table is a separate task (defined as a single monitoring event), and each column is a task property. The task properties indicate such items as when to run an SQL statement, stored procedure, or UDR and how to handle the task. An example of a task is the automatic running of a particular job every Monday at midnight.
The scheduler
The scheduler enables the database server to execute database functions and procedures at predefined times or as determined internally by the server. The functions and procedures collect information, and monitor and adjust the server, using an SQL-based administrative system and a set of tasks.
The scheduler manages and executes scheduled maintenance, monitoring, and administration tasks. This tool enables you to monitor activities (for example, space management or automatically backing up any new log data at timed intervals since the last log backup) and create corrective actions that run automatically.
The scheduler manages:
- Tasks, which provide the means for running a specific job at a specific time or interval
- Sensors, which collect and save information
- Startup tasks, which run only once when the database server starts
- Startup sensors, which run only once when the database starts
A set of task properties, which define what needs to be collected or executed, control the scheduler. The task properties are stored in the ph_task table in the sysadmin database.
Each row in this table is a separate task, and each column is a task property. The task properties indicate to the system such things as when to run an SQL statement, stored procedure, or function and how to handle the task.
For example, you could define tasks to check free log space every hour from 9:00:00 to 19:00:00, daily.
Only task properties, not configuration parameters, define what the scheduler collects and executes. The scheduler executes tasks at predefined times or as determined internally, as required by the database server.
Table 2. Built-in tasks
|Purges the command history table
|Saves any changes in the ONCONFIG file
|Saves the ONCONFIG file on every server startup
|Collects virtual processor information
|Saves information about checkpoints
|Saves table profile information, including the total number of updates, inserts, and deletes that occurred on this table
|Saves the table names along with their creation time
|Saves profile information about each user
|Checks to ensure that backups have run
You can modify these tasks and set up more tasks.
Setting up tasks
To set up a task, you need to plan the task first. You need to have:
- A description of the task you want to monitor
- The table where you want to store data
- The SQL command, stored procedure, or function to capture data
- Information on when and how often you want the task to run
You can use SQL to insert a new row into the ph_task table, as shown in the following examples. Also include values that will be displayed in table columns.
The following example in Listing 1 shows the code for the creation of a table, called mon_chunkio, that uses a stored procedure to collect and store data. This task instructs the database server to collect data every five minutes by executing a stored procedure called chunkio. The default scheduling policy (for example, 8:00 A.M. to 5:00 P.M., five days a week) is used, but the data expires and is deleted when it becomes seven days old.
Listing 1. Creating a table that uses a stored procedure to collect and store data
INSERT INTO ph_task ( tk_description, tk_result_table, tk_create, tk_execute, tk_frequency, tk_delete ) VALUES ( "Chunk I/O counts and space usage", "mon_chunkio", "create table mon_chunkio (ID integer, chunknum smallint, free integer, size integer, reads integer, pagereads integer, writes integer, pageswritten integer)", "chunkio", "0 0:05:00", "7 0:00:00" );
Setting up sensors
A sensor is a specialized TASK for collecting and saving data. A sensor can be created the same way as a task by inserting a row in the ph_task table, with some additional information.
To set up a new sensor, you need to plan first. You need to have:
- A description of the sensor
- The result table to save collect information
- SQL object, stored procedure, or a function to collect information
- Information on when and how often the sensor needs to run
The following example in Listing 2 shows the code for a sensor that collects information about the amount of memory that is being used and stores the information in the mon_memory_system table. If that table does not exist, the task creates it. This task, which runs every 30 minutes, deletes any data in the mon_memory_system table that has existed for more than 30 days.
Listing 2. Collecting information about the amount of memory that is being used and storing data in the mon_memory_system table
INSERT INTO ph_task (tk_name, tk_type, tk_group, tk_description, tk_result_table, tk_create, tk_execute, tk_stop_time, tk_start_time, tk_frequency, tk_delete ) VALUES ("mon_memory_system", "SENSOR", "MEMORY", "Server memory consumption", "mon_memory_system", "create table mon_memory_system (ID integer, class smallint, size int8, used int8, free int8 )", "insert into mon_memory_system select $DATA_SEQ_ID, seg_class, seg_size, seg_blkused, seg_blkfree FROM sysmaster:sysseglst", NULL, NULL, INTERVAL ( 30 ) MINUTE TO MINUTE, INTERVAL ( 30 ) DAY TO DAY);
Modifying tasks
You can modify the tasks by modifying the rows in the tables that begin with the characters ph_ in the sysadmin database.
Go to the ph_task or other table that you want to modify in the sysadmin database. Manually change the task information.
Command history table
The command_history table in the sysadmin database contains historical information about the SQL administration API commands executed on this data server.
The system-monitoring interface
The system-monitoring interface (SMI) tables are special tables managed by the
database server that contain dynamic information about the state of the database
server. You can use
SELECT statements on them to determine almost anything you might
want to know about your database server.
The buildsmi script
When you bring the database server up for the first time, it runs a script called buildsmi, which is in the $INFORMIXDIR/etc directory. This script builds the sysmaster database and tables that support SMI. The database server requires approximately 1750 free pages of logical-log space to build the sysmaster database.
If you receive an error message that directs you to run the buildsmi script, a problem probably occurred while the database server was building the SMI database, tables, and views. When you use buildsmi, the existing sysmaster database is dropped and then recreated.
The bldutil.sh script
The sysutils database is the place where OnBar stores information about every backup/restore it performed. Backup information on every dbspaces and logical logs is also stored here. OnBar utilizes these tables when performing warm restores.
When you initialize the database server for the first time, it runs a script called bldutil.sh on UNIX® or bldutil.bat on Windows®. This script builds the sysutils database. If it fails, the database server creates an output file in the tmp directory. The output file is bldutil.process_id on UNIX and bldutil.out on Windows. The messages in this output file reflect errors that occurred during the script execution.
The sysmaster database
The sysmaster database is described as a pseudo database. That means most of its tables are not normal tables on disk, but pointers to shared memory structures in the IDS engine. The sysmaster database contains over 120 tables. Only some of these tables are documented in the Informix Dynamic Server Administrators Guide. The rest are undocumented and meant to be as such for internal use.
These are new tables introduced in Version 11. There are many others sysmaster tables that you can find more details on in the manual.
Table 3. New sysmaster tables
|The information about the checkpoint and associated statistics
|Modified the existing table to add wait stats
|View Informix s session environment variables
|View the servers environment variables
|View the online.log for the server
|Improvement to view the memory used by session
|View the network I/O generated by database session
|Oracle compatibility feature
|Displays the profile information about each SQL cache
|The SQL statements that have been recently executed on the system
|The list of iterators for the SQL statement
|General information about the SQL tracing
|Global Network Information
|Network information based on client type
|The OnBar activity log file
|Improvement to view I/O and lock wait information
Understanding the SMI tables
The SMI consists of tables and pseudo-tables that the database server maintains automatically. While the SMI tables appear to the user as tables, they are not recorded on disk as normal tables are. Instead, the database server constructs the tables in memory, on demand, based on information in shared memory at that instant. When you query an SMI table, the database server reads information from these shared-memory structures. Because the database server continually updates the data in shared memory, the information that SMI provides lets you examine the current state of your database server.
The SMI tables provide information about the following topics:
- Auditing
- Disk usage
- User profiling
- Database-logging status
- Tables
- Chunks
- Chunk I/O
- Dbspaces
- Locks
- Extents
- SQL statement cache statistics
- Virtual-processor CPU usage
- System profiling
The data in the SMI tables changes dynamically as users access and modify databases that the database server manages.
Accessing SMI tables
Any user can use SQL
SELECT statements to query an SMI table, but standard users cannot
execute statements other than
SELECT. Attempts to do so result in permission errors.
The administrator can execute SQL statements other than
SELECT, but the results of
such statements are unpredictable.
Dynamic Server provides the sysadtinfo and sysaudit tables. Only user informix on UNIX or members of the Informix-Admin group on Windows can query sysadtinfo and sysaudit.
You cannot use
dbschema or
dbexport on any of the tables in the sysmaster database. If
you do, the database server generates the following error message:
Database has pseudo tables - can't build schema
You can use
SELECT statements on SMI tables wherever you can use
SELECT against
ordinary tables (from DBAccess, in an SPL routine, with ESQL/C, and so on) with one
restriction: You cannot (meaningfully) reference rowid when you query SMI tables.
SELECT statements that use rowid do not return an error, but the results are
All standard SQL syntax, including joins between tables, sorting of output, and so on, works with SMI tables. For example, if you want to join an SMI table with a non-SMI table, name the SMI table with the following standard syntax:
Intention:: List of users who had a database open and which workstation they were using to connect to the database.
- The
onstat -uutility would tell which users were connected to the server, but not what database and what workstation they were using.
Onstat -g seswould tell the user and workstation, but not the database.
Onstat -g sqlwould tell the session ID and database, but not the user name and workstation.
Listing 3. Example
QUERY SELECT sysdatabases.name database, syssessions.username, syssessions.hostname, syslocks.owner sid FROM syslocks, sysdatabases, outer syssessions WHERE syslocks.tabname = "sysdatabases" AND syslocks.rowidlk = sysdatabases.rowid AND syslocks.owner = syssessions.sid; OUTPUT database stores_demo username informix hostname istation1 sid 27 database sysmaster username informix hostname istation1 sid 29
The onstat utility
onstat utility provides a way to monitor database server shared memory from the
command line. The
onstat utility reads data from shared memory and reports
statistics that are accurate for the instant during which the command executes. That
onstat provides information that changes dynamically during processing,
including changes in buffers, locks, indexes, and users.
Monitor the database server status
onstat output heading indicates the database server status. Whenever the
database server is blocked,
onstat displays the following
line after the banner
line: All
onstat output includes a header. The
onstat - option displays only the
output header and is useful for checking the database server mode. The header takes
the following form:
Version--Mode (Type)--(Checkpnt)--Up Uptime--Sh_mem Kbytes
Listing 4. Onstat syntax
>>-onstat-------------------------------------------------------> .-----------------------------. V (1) >--+-+-----------------+----+-------------------------+-+------+-> '-filename_source-' +- -a---------------------+ +- -b---------------------+ +- -B---------------------+ +- -c---------------------+ +- -C---------------------+ +- -d---------------------+ +- -D---------------------+ +- -f---------------------+ +- -F---------------------+ +- -g--Monitoring options-+ +- -G---------------------+ +- -i---------------------+ +- -k---------------------+ +- -K---------------------+ +- -l---------------------+ +- -m---------------------+ +- -o--+---------------+--+ '-filename_dest-' +- -O---------------------+ +- -p---------------------+ +- -P---------------------+ +- -r--+---------+--------+ '-seconds-' +- -R---------------------+ +- -s---------------------+ +- -t---------------------+ +- -T---------------------+ +- -u---------------------+ +- -x---------------------+ +- -X---------------------+ '- -z---------------------' +- ---------------------------------------------------------+ '- ---------------------------------------------------------
Note: Only one occurrence of each item is allowed. More than one option can be
specified on a single
onstat command invocation.
Table 4. Onstat options
|Displays the output header
|Displays a listing of all
onstat options and their functions
|Interpreted as
onstat -cuskbtdlp; displays output in that order
|Displays information about buffers currently in use, including number of resident pages in the buffer pool
|Obtains information about all database server buffers, not just buffers
currently in use. See the entry for
-b in this table
|Displays the ONCONFIG file: * $INFORMIXDIR/etc/ $ONCONFIG for UNIX * %INFORMIXDIR%\etc\ %ONCONFIG% for Windows
|Prints B-tree scanner information
|Displays information for chunks in each storage space
|Displays page-read and page-write information for the first 50 chunks in each dbspace
|Lists the dbspaces currently affected by the DATASKIP feature
|Displays a count for each type of write that flushes pages to disk
|Provides monitoring options
|Prints global transaction IDs
|Puts the
onstat utility into interactive mode
|Prints the interactive status of the active onpload process
|Displays information about active locks
|Displays information about physical and logical logs, including page addresses
|Displays the 20 most recent lines of the database server message log
|Saves copies of the shared-memory segments to filename
|Displays information about the Optical Subsystem memory cache and staging-area blobspace
|Displays profile counts
|Displays for all partitions the partition number and the break-up of the buffer-pool pages that belong to the partition
|Repeats the accompanying
onstat options after they wait the specified
seconds between each execution. The default value of seconds is five.
|Displays detailed information about the LRU queues, FLRU queues, and MLRU queues
|Displays general latch information
|Displays tblspace information, including residency state, for active tblspaces
|Displays tblspace information for all tblspaces
|Prints a profile of user activity
|Displays information about transactions
|Obtains precise information about the threads that are sharing and waiting for buffers
|Sets the profile counts to zero
|Specifies destination file for the copy of the shared-memory segments
|Specifies file that
onstat reads as source for the requested
|Monitoring options
|Specifies which
onstat -g monitoring option to use
|Specifies number of seconds between each execution of the
onstat -r command
onstat g monitoring options
The following
onstat -g options are provided for support and debugging only. You can include only one of these options per
onstat -g command. For more information, see your IBM Informix Performance Guide.
Table 5. onstat -g options
|onstat -g option
|Topic or function
|-g act
|Active threads. For example output, see the
onstat -g
act option.
|-g afr pool name session id
|Prints allocated memory fragments for a specified session or shared-memory pool.
Each session is allocated a pool of shared memory. To obtain the pool name, see
-mem option. For example output, see the
onstat -g afr pool name session id option.
|-g all
|Prints all multithreading information
|-g ath
|Prints all threads. The sqlmain threads represent client sessions. The rstcb
value corresponds to the user field of the
onstat -u
command. For example output, see the
onstat -g ath option. For information on using
onstat -g ath to print Enterprise Replication threads, see the IBM Informix Dynamic Server Enterprise Replication Guide.
|-g cat [modifier]
|Prints information from the Enterprise Replication global catalog. The global
catalog contains a summary of information about the defined servers, replicates,
and replicate sets on each of the servers within the enterprise. For more information and sample output, see the
onstat -g cat option.
|-g cac agg
|Prints the definitions for user-defined aggregates that are currently in the cache
|-g cac stmt
|Prints the contents of the SQL statement cache. Prints the same output as the
-g ssc statement.
|-g con
|Prints conditions with waiters. For example output, see the
onstat -g con option.
|-g ddr
|Prints the status of the Enterprise Replication database log reader. If log
reading is blocked, data might not be replicated until the problem is resolved.
For more information and sample output, see the
onstat -g ddr option.
|-g dic table
|Without any parameters, prints one line of information for each table cached in
the shared-memory dictionary. If given a specific table name as a parameter,
prints internal SQL information for that table. For more information, see your IBM Informix Performance Guide. For sample output, see the
onstat -g dic table option.
|-g dis
|Prints a list of database servers and their status, and information about each
database server, INFORMIXDIR, sqlhosts file, ONCONFIG file, and hostname. For
example output, see the
onstat -g dis option.
|-g dll
|Prints a list of dynamic libraries that have been loaded. For example output,
see the
onstat -g dis option.
|-g dri
|Prints data-replication information. See monitoring High-Availability
Data-Replication status in the IBM Informix Administrator's Guide. For example
output, see the
onstat -g dri option.
|-g dsc
|Prints data-distribution cache information. For example output, see the
onstat -g dsc option.
|-g dss [modifier]
|Prints detailed statistical information about the activity of individual data
sync threads and about user-defined data types. For more information and sample
output, see the
onstat -g dss option.
|-g dtc
|Prints statistics about the delete table cleaner, which removes rows from the
delete table when they are no longer needed. For more information and sample
output, see the
onstat -g dtc option.
|-g env
|Prints the values of environment variables the database server currently uses.
For more information, see the
onstat -g env option.
|-g ffr pool name session id
|Prints free fragments for a pool of shared memory. For example output, see the
onstat -g ffr pool name session id option.
|-g glo
|Prints global multithreading information. This information includes CPU use
information about the virtual processors, the total number of sessions, and other
multithreading global counters. On Windows, the virtual processors are operating
system threads. The values displayed under the 'pid' field are thread ids, not process ids (Windows). For example output, see the
onstat -g glo option.
|-g grp [modifier]
|Prints statistics about the Enterprise Replication grouper. The grouper
evaluates the log records, rebuilds the individual log records into the original
transaction, packages the transaction, and queues the transaction for transmission. For more information and sample output, see the
onstat -g grp option.
|-g his
|Prints information about the SQLTrace configuration parameter
|-g imc
|Prints information about MaxConnect instances that are connected to the database server. If MaxConnect is not connected to the database server, this command displays No MaxConnect servers are connected.
|-g ioa
|Prints combined information from -
g ioq and
-g iov. For example output, see the
onstat -g
ioa option.
|-g iob
|Prints the big buffer usage summary. For example output, see the
onstat -g iob option.
|-g iof
|Prints asynchronous I/O statistics by chunk or file. This option is similar to
-D option, except it also displays information on
nonchunk, temporary, and sort-work files. For example output, see the
onstat -g iof option.
|-g iog
|Prints AIO global information. For example output, see the
onstat -g iog option.
|-g ioq queue name
|Prints pending I/O operations for the queue name. If given the gfd or kaio queue
name, a queue for each CPU VP is displayed. If queue name is omitted, I/O
statistics for all queues are displayed. For example output, see the
onstat -g ioq queue name option.
|-g iov
|Prints asynchronous I/O statistics by virtual processor. For example output, see
onstat -g iov option.
|-g ipl
|Prints index page logging status
|-g lmx
|Prints all locked mutexes. For example output, see the
onstat -g lmx option.
|-g lsc
|Displays information about light scans
|-g mem pool name session id
|Prints statistics for a memory pool. Also displays the pool name, type of shared
memory segment that contains the pool, the address of the pool, the total size of
the pool, the number of bytes of free memory that it contains, and the number of free and allocated fragments in the pool. If no argument is provided, displays information about all pools. The block pools are listed in a separate section after the main pool list. You also can use ISA to obtain detailed information about a memory pool. If you run an SQL query that allocates memory from the PER_STMT_EXEC and PER_STMT_PREP memory duration pools,
onstat -g mem displays information on the PRP.sessionid.threadid pool and the EXE.sessionid.threadid pool. For example output, see the
onstat -g mem pool name session id option. For more information, see the IBM Informix DataBlade API Programmer's Guide.
|-g mgm
|Prints Memory Grant Manager resource information. For example output, see the
onstat -g mgm option.
|-g nbm
|Prints block bit map for the nonresident segments, one bit per 8-kilobyte block.
Bit set indicates block free. For example output, see the
onstat -g nbm option.
|-g nif [modifier]
|Prints statistics about the network interface. Useful to determine why data is
not replicating. For more information and sample output, see the
onstat -g nif option.
|-g nsc client id
|Prints shared-memory status by client id. If client id is omitted, all client
status areas are displayed. This command prints the same status data as the nss
command. For example output, see the
onstat -g nsc client_id option.
|-g nsd
|Prints network shared-memory data for poll threads. For example output, see the
onstat -g nsd Option.
|-g nss session id
|Prints network shared-memory status by session id. If session id is omitted, all session status areas are displayed. This command prints the same status data as the
nsc command.
|-g nta
|Prints combined network statistics from -
g ntd,
-g ntm,
-g ntt, and
-g ntu. If MaxConnect is installed, this command prints statistics that you can use to tune MaxConnect performance.
|-g ntd
|Prints network statistics by service. For example output, see the
onstat -g ntd option.
|-g ntm
|Prints network mail statistics. For example output, see the
onstat -g ntm option.
|-g ntt
|Prints network user times. For example output, see the
onstat -g ntt option.
|-g ntu
|Prints network user statistics. For example output, see the
onstat -g ntu option.
|-g pos
|Prints $INFORMIXDIR/etc/ .infos.DBSERVERNAME file for UNIX and
%INFORMIXDIR%\etc\ .infos.DBSERVERNAME for Windows. For example output, see the
onstat -g pos option.
|-g ppf partition number 0
|Prints partition profile for partition number; 0 prints profiles for all
partitions. If TBLSPACE_STATS configuration parameter is set to 0, displays:
Partition profiles is disabled. For example output, see the
onstat -g ppf partition number 0 option.
|-g prc
|Prints information about SPL routine cache. For example output, see the
onstat -g prc option.
|-g qst
|Prints queue statistics
|-g que
|Prints statistics for the high-level queue interface (which are common to all
the queues of the Enterprise Replication Queue Manager). For more information and
sample output, see the
onstat -g que option.
|-g rbm
|Prints block bit map for the resident segment (communication message area). For
example output, see the
onstat -g rbm option.
|-g rcv [serverid]
|Prints statistics about the receive manager, which is a set of service routines
between the receive queues and data sync. For more information and sample output,
see the
onstat -g rcv option.
|-g rea
|Prints ready threads. For example output, see the
onstat -g
rea option.
|-g rep [replname]
|Prints events that are in the queue for the schedule manager. For more
information and sample output, see the
onstat -g rep option.
|-g rqm [modifier]
|Prints statistics and contents of the low-level queues (each individual queue)
managed by the Reliable Queue Manager (RQM). For more information and sample
output, see the
onstat -g rqm option.
|-g rwm
|Prints read/write mutexes. For example output, see the
onstat -g rwm option.
|-g sch
|Prints the number of semaphore operations, spins, and busy waits for each
virtual processor. On Windows, the virtual processors are operating system
threads. The values displayed under the 'pid' field are thread ids not process ids
(Windows). For example output, see the
onstat -g sch option.
|-g seg
|Prints shared-memory-segment statistics. This option shows the number and size
of shared-memory segments that the database server is currently using. For example
output, see the
onstat -g seg option.
|-g ses sessionid
|Prints session information by sessionid. If sessionid is missing, a one-line
summary of each session prints. For more information, see the
onstat -g ses option.
|-g sle
|Prints all sleeping threads. For example output, see the
onstat -g sle option.
|-g smb option
|Prints detailed information about sbspaces. For more information, see the
onstat -g smb option.
|-g smxoption
|Displays server multiplexer group connections information
|-g spi
|Prints spin locks that virtual processors have spun more than 10,000 times to acquire. These spin locks are called longspins. The total number of longspins is printed in the heading of the
glo command. Excessive longspins might indicate an overloaded system, too many virtual processors for a given computer or node, or an internal problem. To reduce longspins, reduce the number of virtual processors (generally class CPU), reduce the load on the computer, or use the no-age or processor affinity features.
|-g sql session id
|Prints SQL information by session id. If session id is omitted, a one-line
summary for each session prints. For more information, see the
onstat -g sql option.
|-g ssc
|Monitors the number of times that the database server reads the SQL statement in
the cache. For example output, see the
onstat -g ssc option. Displays the same output as
onstat -g cac stmt. For more information, see improving query performance in the IBM Informix Performance Guide.
|-g ssc all
|Reports the key-only cache entries as well as the fully cached statements. If the value in the hits column is less than the STMT_CACHE_HITS value, that entry is a key-only cache entry. For more information, see memory utilization in the IBM Informix Performance Guide.
|-g ssc pool
|Reports usage of all memory pools for the SQL statement cache. The output displays information on the name, class, address, and total size of the memory pools. For more information, see improving query performance in the IBM Informix Performance Guide.
|-g stk tid all
|Dumps stack of thread specified by thread ID or stacks for all threads. This
option is not supported on all platforms and is not always accurate. For example
output, see the
onstat -g stk tid option.
|-g stm [session id]
|Displays the memory that each prepared SQL statement uses. For example output,
see the
onstat -g stm option.
For more information, see memory utilization and improving query performance in the IBM Informix Performance Guide.
|-g sts
|Prints maximum and current stack use per thread. For example output, see the
onstat -g sts option.
|-g sync
|Shows which sync is active. For example output, see the
onstat -g sync option.
|-g tpf tid
|Prints thread profile for a specific thread ID. For example output, see the
onstat -g tpf tid option.
|-g ufr pool name session id
|Prints allocated fragments by use
|-g vpcache
|Returns information about CPU VP memory block cache statistics
|-g wai
|Prints waiting threads; all threads waiting on mutex or condition, or yielding
|-g wmx
|Prints all mutexes with waiters. For example output, see the
onstat -g wmx option.
|-g wst
|Prints wait statistics
Statistics called from source file
Use the
filename_source parameter with other option flags to derive the requested
onstat statistics from the shared-memory segments that filename_source contains.
You must first use the
onstat -o command to create a file that contains the
shared-memory segments.
Listing 5. Calling statistics from source file
Creating a snapshot of the shared memory for further analysis onstat -o myfile Checking some information, for example dbspace information onstat -d myfile Results Dbspaces address number flags fchunk nchunks pgsize flags owner name ad357e8 1 0x60001 1 1 2048 N B informix rootdbs b62a5b0 2 0x60001 2 1 4096 N B informix dbsp1 2 active, 2047 maximum Chunks address chunk/dbs offset page Rd page Wr pathname ad35948 1 1 0 493 5803 /local0/engines/ol_tuxedo/ifmxdata/rootdbs b62a710 2 2 0 4 20 /local0/engines/ol_tuxedo/ifmxdata/dbsp1 2 active, 32766 maximum NOTE: The values in the "page Rd" and "page Wr" columns for DBspace chunks are displayed in terms of system base page size. Expanded chunk capacity mode: always
Interactive execution
To put the
onstat utility in interactive mode, use the
-i option. Interactive mode
allows you to enter multiple options, one after the other, without exiting the
program. For information on using interactive mode, see
onstat -i.>
Continuous onstat execution
Use the
seconds parameter with the
-r option flag to cause all other flags to execute
repeatedly after they wait the specified seconds between each execution.
The oncheck utility
oncheck utility displays information about the database disk configuration and usage, such as the number of pages used for a table, the contents of the reserved pages, and the number of extents in a table.
oncheck utility is invoked by executing the
oncheck command. The simplest form of the command is shown in Listing
6, below:
Listing 6. Oncheck syntax
oncheck <-option> <database | database:owner.table | tablespacenum logical pagenum ... > <-x> <-n> <-y> -x Places a shared lock on the table when you check and print an index -n Indicates that no index repair should be performed, even if errors are detected Use with the index repair options (-ci, -cI, -pk, -pK, -pl, and -pL). -y Repairs indexes when errors are detected.
Table 6. Oncheck options
|Checks system catalog tables for the specified database
|Reads all pages, except simple large objects from the tblspace for the specified database, table, or fragment, and checks each page for consistency. Also checks tables that use a user-defined access method. Does not check simple or smart large objects.
|Same as
-cd, but also reads the header of each
blobpage and checks it for consistency. Checks simple large objects but not smart large objects.
|Checks each chunk-free list, corresponding free space, and each tblspace extent. Also checks smart-large-object extents and sbspace metadata. The oncheck process verifies that the extents on disk correspond to the current control information that describes them.
|Checks the ordering of key values and the consistency of horizontal and vertical node links for all indexes associated with the specified table. Also checks indexes that use a user-defined access method.
|Same as
-ci, but also checks that the key value tied to a rowid in an index is the same as the key value in the row
|Checks each of the root dbspace reserved pages for several conditions
|Checks the root dbspace reserved pages, physical-log pages, and logical-log pages
|Checks smart large object and sbspace metadata for an sbspace
|Checks smart large object and sbspace metadata for an sbspace as well as extents
|Displays statistics that describe the average fullness of blobspace blobpages in a specified table. These statistics provide a measure of storage efficiency for individual simple large objects in a database or table. If a table or fragment is not specified, statistics are displayed for the entire database.
|Same as
-cc, but also displays the system catalog information as it checks the system catalog tables, including extent use for each table None
|Displays rows in hexadecimal format
|Displays rows in hexadecimal format and simple-large-object values stored in the tblspace or header information for smart large objects stored in an sbspace sbpage, and simple large objects stored in a blobspace blobpage
|Same as
-ce but also displays the chunk and tblspace extent information as it checks the chunk free list, the corresponding free space, and each tblspace extent
|Same as
-ci, but also displays the key values for all indexes on the specified table as it checks them
|Same as
-ci, but also displays the key values. Only leaf-node index pages are checked.
|Same as
-cI, but also displays the key values and rowids for leaf-node index pages only
|Displays contents of a logical page
|Same as
-pp, but requires a chunk number and logical page number or internal rowid as input
|Same as
-cr, but also displays the reserved-page information as it checks the reserved pages
|Checks and displays smart-large-object and sbspace metadata for an sbspace
|Checks and displays smart-large-object and sbspace metadata. Lists extents and header information for individual smart large objects.
|Displays tblspace information for a table or fragment
|Same as
-pt, but also displays index-specific information and page-allocation information by page type (for dbspaces)
Check and repair
oncheck utility can repair the following types of disk structures:
- Partition-page statistics
- Bitmap pages
- Partition blobpages
- Blobspace blobpages
- Indexes
- Sbspace pages
- Metadata partitions for sbspaces
oncheck detects inconsistencies in other structures, messages alert you to these inconsistencies, but
oncheck cannot resolve the problem.
Repairing indexes in sbspaces and external spaces
oncheck utility can repair an index in an sbspace or external space if the index is created using an access method that supports the
oncheck -y option. Although the
oncheck utility does not repair fragmented indexes, user-defined access methods can repair them.
Locking and oncheck
oncheck utility places a shared lock on a table during the following operations, so no other users can perform updates, inserts, or deletes until the check has completed:
- When it checks data
- When it checks indexes (with
-pl, or
-pL), and the table uses page locking
- When you specify the
-xoption with
-pl, or
-pL, and the table uses row locking
If the table does not use page locking, the database server does not place a shared lock on the table when you check an index with the
oncheck -ci,
-pl, or
-pL options. When no shared lock is on the table during an index check, other users can update rows during the check.
By not placing a shared lock on tables using row locks during index checks, the
oncheck utility cannot be as accurate in the index check. For absolute assurance of a complete index check, you can execute
oncheck with the
-x option. With the
-x option,
oncheck places a shared lock on the table, and no other users can perform updates, inserts, or deletes until the check has completed.
Message log
The database server message log is an operating system file. The messages contained in the database server message log do not usually require immediate action.
To specify the message log path name, set the MSGPATH configuration parameter. The changes to MSGPATH take effect after you shut down and restart the database server.
Monitoring message log
You should monitor the message log once or twice a day to ensure that processing is
proceeding normally and that events are being logged as expected. Use the
onstat -m command to obtain the name of the message log and the 20 most recent entries. Use a text editor to read the complete message log. Use an operating system command (such as the UNIX command
tail -f) to see the messages as they occur.
Monitor the message log size, because the database server appends new entries to this file. Edit the log as needed, or back it up to tape and delete it.
If the database server experiences a failure, the message log serves as an audit trail for retracing the events that develop later into an unanticipated problem. Often the database server provides the exact nature of the problem and the suggested corrective action in the message log.
You can read the database server message log for a minute-by-minute account of database server processing in order to catch events before a problem develops. However, you do not need to perform this kind of monitoring.
Message categories
Four general categories of unnumbered messages exist, although some messages fall into more than one category:
- Routine information
- Assertion-failed messages
- Administrative action needed
- Fatal error detected
Examples of message log messages
Listing 7. Example of routine messages
Wed Apr 18 19:01:23 2007 22:56:00 Maximum server connections 284 22:56:03 Level 1 Archive started on dbsherm05 23:23:40 Logical Log 42173 Complete, timestamp: 0xeee826ad. 23:23:41 Logical Log 42173 - Backup Started 23:24:26 Logical Log 42173 - Backup Completed 23:26:30 Checkpoint Completed: duration was 29 seconds, 36019 buffers not flushed. 23:26:30 Checkpoint loguniq 42174, logpos 0x281d658, timestamp: 0xeeece592
Listing 8. Example of assertion-failed messages
19:12:26 Who: Session(33, informix@rdbms2, 0, 25da90ba8) Thread(63, xchg_1.6, 25da5d308, 1) File: rspartn.c Line: 2426 19:12:26 Results: Could not complete operation on 'erv:"informix".stmy' 19:12:26 Action: Run 'oncheck -cDI ermes:"informix".avvisi_out_tot_e2' 19:12:26 stack trace for pid 1474 written to /appl/InformixDump/af.4274f8a 19:12:26 See Also: /appl/InformixDump/af.4274f8a 19:12:38 ptmap 19:12:38 Assert Failed: ptmap
Listing 9. Example of administrative action needed messages
11:05:49 Maximum server connections 4 11:08:05 Logical Log Files are Full -- Backup is Needed
Listing 10. Example of fatal error messages
15:24:33 IBM Informix Dynamic Server Started. 15:24:33 shmget: [EEXIST][17]: key 52584801: shared memory already exists 15:24:33 mt_shm_init: can't create resident segment 15:40:09 Assert Failed: Unexpected virtual processor termination, pid = 526411, exit = 0x9
Event alarms
The database server provides a mechanism for automatically triggering
administrative actions based on an event that occurs in the database server
environment. This mechanism is the event-alarm feature. Events can be informative
(for example, backup complete) or can indicate an error condition that requires your
attention (for example, unable to allocate memory). To use the event-alarm feature, set the
ALARMPROGRAM configuration parameter to the full pathname of an executable file that performs the necessary administrative actions.
The database server can execute a program that operates either whenever certain noteworthy event alarms occur or every time any event alarm occurs. Noteworthy event alarms include failure of a database, table, index, chunk, or dbspace taken offline, internal subsystem failure, start-up failure, and detection of long transaction. You can receive notification of an event alarm through e-mail or pagermail.
Use the following parameters in Table 7 to specify:
- Whether the event-alarm program operates for all or only certain event alarms
- What actions to take when alarm events occur
Table 7. Event-alarm parameters
|Specifies whether
ALARMPROGRAM runs for all events that are logged in the MSGPATH or only specified noteworthy events
|Specifies the location of a file that is executed when an event alarm occurs
Operating system tools
UNIX tools
System activity reporter (SAR)
sar command is useful for monitoring CPU
utilization, disk activity, and memory utilization.
Listing 11. sar example
$ sar -u 60 10 09:42:17 %usr %sys %wio %idle 09:43:17 1 5 0 94 09:44:17 1 4 0 95 09:45:17 5 3 0 92 09:46:17 4 6 1 89
The example shown in Lising 11 monitors CPU utilization at intervals of 60 seconds for 10 iterations.
To identify potential or actual performance bottlenecks or problems, it is necessary to continuously monitor your system and capture these data points over an extended period of time.
The UNIX
sar command is particularly useful for creating
and maintaining long-term performance histories:
saris available on all IBM Informix IDS-hardware platforms
- When run with a named output file, a single binary-encoded file is created from which all
sarreports can be generated at a later time
time or timex
time and
timex commands allow you to time the running of a process. Both
time and
timex report on real time as well as user and system CPU time.
The ps command is a good source of snapshot information about system processes currently running.
Listing 12. Process status (ps)
$ ps -el S UID PID PPID STIME TTY TIME CMD T root 0 0 08:59:54 ? 0:01 sched S root 1 0 08:59:57 ? 0:00 /etc/init S root 434 1 09:03:51 ? 0:05 oninit S root 435 434 09:03:53 ? 0:00 oninit S root 445 434 09:06:02 ? 0:00 oninit where PID is Process Id STIME is process start time TIME is accumulated CPU time for process
iostat command provides highly accurate measures of
throughput, utilization, queue lengths, transaction rates, and service times.
Listing 13. The iostat command
$ iostat -x 5 1 extended device statistics device r/s w/s Kr/s Kw/s wait actv svc_t %w %b sd0 6.2 0.0 21.5 0.0 0.0 0.1 24.1 0 15 sd1 1.8 0.0 14.3 0.0 0.0 0.1 41.6 0 7 sd6 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 sd30 0.2 0.2 25.7 0.2 0.0 0.1 22.5 0 13
vmstat command provides information about the status of processes, memory utilization, paging statistics, system activity, and CPU usage.
Listing 14. The iostat command
$ vmstat 5 4 procs memory page disk faults r b w swap fre re mf pi po ... d0 d1 d2 in sy ... 4 1 0 104512 1792 8 0 288 192 ... 4 6 1 23 15 ... 2 3 0 105184 1952 4 0 96 128 ... 0 2 1 14 15 ... 3 2 0 106688 1952 7 0 256 224 ... 4 4 12 29 21 ... 4 2 0 104672 6240 4 0 384 32 ... 3 1 3 2 75 ... where w is processes swapped out page outs swap is Kbytes of swap space available d0 is # of disk operations/sec p0 is pageouts
Windows event viewer
The event viewer shows informational, warning, and error messages for the operating system, other applications, and the database server.
To display database server messages on Windows:
- Choose Administrative Tools > Event Viewer.
- Choose Log > Security.
- Double-click any event for a more detailed message.
Windows utilities
The following Informix utilities simplify administration of the database server on Windows.
ixpasswd.exe changes the logon password for all services that log on as user informix. You can
change the password interactively or on the command line using the
-y option. This
utility saves having to manually change the password for each service whenever you
change the informix password.
If you are logged on locally and run ixpasswd, it changes the password for services that log on as the local informix user. If you are logged on domain and run ixpasswd, it changes the password for services that log on as domain\informix.
ixpasswd [-y new_password]
Launches a command-line window that runs as the specified user. The user is a local user unless you specify a domain name. If you do not specify a user name, the default user is informix. You no longer need to log off as the current user and log on as informix to perform DBA tasks that need to be run as informix. The ixsu utility requires advanced user rights:
Act as part of the operating system
- Increase quotas
- Replace a process-level token
- To configure advanced user rights on Windows NT:
- Select User Manager > Policies > User Rights
- Check the Advanced User Rights option.
Note: If you change the advanced user rights for the current user, you need to log off and log back on for the new rights to take effect
ixsu [[domain\]username]
The ixsu utility is equivalent to the Windows 2000
runas command. To use
runas to run a
command shell as another user:
runas /user:username cmd
ntchname.exe changes the registry entries for Dynamic Server from the old hostname to the new hostname. Run ntchname after you change the hostname. This utility does not change user environment variables. After you execute ntchname, edit the %INFORMIXDIR%\%INFORMIXSERVER%.cmd file and change the INFORMIXSQLHOSTS entry to the new hostname.
ntchname old_name new_name
This tutorial introduced you to the set of monitoring tools that are available with IDS 11 and showed you how each are used to monitor how well (or how poorly) your database system is operating. Database monitoring is a vital activity that, when performed on a regular basis, provides continuous feedback on the health of a database system.
The SQL administration API enables you to perform remote administration using various, specific SQL commands for tasks such as managing spaces, managing configuration, running routine jobs, and system validation.
The scheduler manages and executes scheduled maintenance, monitoring, and administration tasks. This tool enables you to monitor activities (for example, space management or automatically backing up any new log data at timed intervals since the last log backup) and create corrective actions that run automatically.
The system-monitoring interface (SMI) tables are special tables managed by the database server that contain dynamic information about the state of the database server. You can use
SELECT statements on them to determine almost anything you might want to know about your database server.
onstat utility provides a way to monitor database server shared memory from the command line. The
onstat utility reads data from shared memory and reports statistics that are accurate for the instant during which the command executes. That is,
onstat provides information that changes dynamically during processing, including changes in buffers, locks, indexes, and users.
oncheck utility displays information about the database disk configuration and usage, such as the number of pages used for a table, the contents of the reserved pages, and the number of extents in a table.
The database server message log is an operating system file. You can read the database server message log for a minute-by-minute account of database server processing in order to catch events before a problem develops.
Event alarm feature is the mechanism for automatically triggering administrative actions based on an event that occurs in the database server environment.
Part 3 of the tutorial series helps you troubleshoot the database server problems.
- developerWorks Informix zone: Read articles and tutorials and connect to other resources to expand your Informix skills.
- IBM Informix Dynamic Server Information Center: Learn more about Informix.
- IBM Informix Dynamic Server 11 BETA Information Center: Learn more about IDS 11.
- developerWorks IDS Experts blog: Find technical notes on Informix Dynamic Server by a worldwide team of Development and Technical Support engineers.
- IBM Information Management certification page: Learn more about resources for IDS certification.
- developerWorks Information Management zone: Learn more about Information Management. Find technical documentation, how-to articles, education, downloads, product information, and more.
- Stay current with developerWorks technical events and webcasts.
- Technology bookstore: Browse for books on these and other technical topics.
Get products and technologies
- Informix Dynamic Server Enterprise Edition V10.0: Download a free trial version.
- Informix Dynamic Server 11: Download the free trial version to work along with this tutorial.
- IBM product evaluation versions: Download and get your hands on application development tools and middleware products from Information Management, Lotus®, Rational®, Tivoli®, and WebSphere®.
- Participate in the discussion forum.
- Check out developerWorks blogs and get involved in the developerWorks community.
Dig deeper into Information management on developerWorks
- Overview
- New to Information management
- Technical library (tutorials and more)
- Forums
- Community
- Downloads
- Products
- Events
developerWorks Premium
Exclusive tools to build your next great app. Learn more.
developerWorks Labs
Technical resources for innovators and early adopters to experiment with.
IBM evaluation software
Evaluate IBM software and solutions, and transform challenges into opportunities.


text:
6,892 words (≈ 28 minutes)
Action Comics: Black Zero, Part 1: That Unnamed Feeling.
First in a biweekly crossover running through Adventures of Superman and Action Comics!
Clark Kent catches a bus and chaos ensues! Downtown Metropolis meets it's city's latest villain! Something lurks far in the depths of space and a intergalactic police officer is confronted by an ancient evil!
Language: English
Written in: 2006
Published: 2009-03-21
Word count: 6,892 words (≈ 28 minutes)
Tags: Green Lantern, Lois Lane, Lex Luthor, Comics, DC2, Superman, witch
Stories starring everyone's favorite Kryptonian both in normal DC2/DC3 continuity and Elseworlds stories.

subset: commoncrawl


text:
Book a Table
AddressGUILDFORD 16/19 Chapel Street Guilford GU1 3UL
01483 577 027
Opening HoursMon - Thur:
11:30 to 22:00 Fri - Sat:
11:30 to 23:00 Sun:
11:30 to 22:00
ASK Italian in Guildford is a place for great food and warm service. Think fresh bread made to tear and share. A glass of fine wine deserving of your time. Delicious main dishes prepared the traditional way. Everything we know and love about Italian food is served straight to your table. Take a look at our Guildford menu and, if you like what you see, book a table.
- Disabled Toilet
- Baby Change Unit
- Free Wifi


text:
Warning: file_get_contents() [function.file-get-contents]: Couldn't resolve host name in /home/cosplayl/public_html/cont/FrontControl.php on line 2167
Warning: file_get_contents(http://rss.api.ebay.com/ws/rssapi?FeedName=SearchResults&siteId=123&language=nl-BE&output=RSS20&sacat=0&ftrt=1&fbd=1&sabdlo=&sabdhi=&saprclo=&saprchi=&floc=1&saslop=1&fsop=1&fsoo=1&from=R6&fss=1&sasl=&sacur=0&afepn=5335848900&customid=Ulquiorra%2BCosplay&saslc=0&fcl=3&saaff=afepn&catref=C5&frpp=100&satitle=Ulquiorra+cosplay+-%28necklace%2Ckey%2Cchain%2Ckeychain%29%2B+&ftrv=1&fts=&salic=23&sascs=0&fspt=0&fpos=&sadis=25&frts=0) [function.file-get-contents]: failed to open stream: operation failed in /home/cosplayl/public_html/cont/FrontControl.php on line 2167
Ulquiorra Cosplay Looking to cosplay a Bleach character? Buy a Ulquiorra Costume here at the Cosplay Locator!
Ulquiorra Schiffer is the fourth Espada, signified by the number four tattooed to his chest. Not many know that he's actually named after a furniture designer named Patricia Urquiola. He's known to attack his own teammates to get them to listen to him, and tends to call people he isn't fond of 'trash'.
We can't stress enough that if you intend to cosplay a character that you should get into that character's head. If you want to cosplay Ulquiorra be sure to act stoic and aloof and maybe beat up a friend or two ^_^
If you need some cosplay help email me at brian at cosplaylocator.com or check out our Cosplay Blog!
Cosplay Locator - Burn your "real clothes"!
No products matching your query have been found in our store at the moment.
Please bookmark this page and come back soon to see if we have what you want.
You may also like to select one of the alternative country flags at the top of the page to show similar items available to you from other eBay stores.
Subscribe to our RSS feed for related items to get them delivered straight to your email address or RSS reader by clicking the orange RSS icon to the left of this message.
What is RSS?
View more Ulquiorra Cosplay items on eBay
Or subscribe to our RSS feed for Ulquiorra Cosplay items.
Or subscribe to our RSS feed for Ulquiorra Cosplay items.
|Chibi Ulquiorra Cifer 4th Espada Bleach Shirt Custom Made T-shirt
See Listing for $...
|Bleach Kapuzenpullover Anime Kapuzenjacke Hoodie
See Listing for $...
|Damen's Short Sleeve Bleach Ulquiorra Schiffer Tank Top Tee Shirts XXXX-L
See Listing for $...
|Bleach Anime Ulquiorra Fabric Wall Scroll Poster (32" x 42") Inches
See Listing for $...
|Bleach Anime Ulquiorra Fabric Wall Scroll Poster (16" x 21") Inches
See Listing for $...
|[apdvprp662fzkpt] Premium Case für iPhone 6 Plus/Bleach Ulquiorra TPU Schutzhülle
See Listing for $...
|Bleach Ulquiorra Cifer Kurosaki Ichigo iPhone 5Â 5S Handy Fall Schwarz 602Â kar107128
See Listing for $...
|Manga Schwert Ulquiorra Cifer
|Bleach Ulquiorra Cifer Symbol-Halskette
See Listing for $...
|Bleach Ulquiorra Schiffer Kost¨¹m
See Listing for $...
Page: 1 of 59 - Next
|Ecchi Girls: Adult Art Book (English Edition)
See Listing for $...


text: Posted March 20, 2012 you already said you bandwagoned them in the past. I'm sure you'll do it again when they're good. thats why you're opinion on anyhting about the team right now shouldn't really be valued. You'll support the team when they're good, or you'll looks like even more a douche than you do now. thats how it is with most people around here anyway. same thing as when I go to a Panthers game and see half the crowd is wearin other teams gear Meh. You don't know what I will or won't do so your opinion on that doesn't have any value. I don't support the Bobcats. I will never support the Bobcats. Share this post Link to post Share on other sites


text:
We're running WP 2.9.2, just upgraded yesterday. Now it appears we have been hacked.
From some external sites, links to our WP site redirect to a malware site [link to malware site removed]. This doesn't happen when typing in our WP URL directly, nor from all external sites, but once it happens from a site, it happens repeatedly.
I can't find any redirect commands in our installation (eg in .htaccess), but I'm not a web expert. I'm reluctant to post our URL, but here is a screen shot of HttpFox header information from one of the redirect events:


text:
Hi. I am in the process of fancying up my blog, and one thing I would like to add is a sidebar slideshow of recipe images. My recipes are all on individual pages, so I would like to show those images and have them link to their recipe page. Does anyone know of a plugin that can do this?
The blog copy I'm working on is here: http://wearychef.gleeson.org
Thanks very much!


text:
Lismore The Legend 21 Year Single Malt WhiskeyOnly 1800 bottles produced.
Rich flavor.
The Legend. View more
Pappy Van Winkle 20 Year Bourbon WhiskeyThe most sought after bourbon whiskey in the world.
The #1 rated bourbon whiskey in the world with a 99 out of 100 rating by the World Spirits Championship. This bourbon is aged 20 years and bottled at 90.4 proof for a wonderfully smooth and rich profile.
view more
Colonel E.H. Taylor Jr.As founding father of the modern bourbon industry, Colonel E.H. Taylor Jr's dedication to distilling began at the close of the Civil War when he began renovation of the O.F.C. Distillery today known as Buffalo Trace Distillery.
Taylor was best known for his whiskey – recognized as topmost class.
View more
Park Cognac by TessendierA boutique cognac house, created by the Tessendier Family, the Park family of Cognacs are fruit forward and delicious.
With a range of products from the best in its class VS, to a boundary pushing Organic Cognac, to the magnificent XO Extra, Park Cognacs are truly for the connoisseur.
view more


text:
The 2011 BCS has a finite allotment of bids and more worthy contenders than it can accommodate.
There are no less than 20 teams that you can remotely imagine playing in a 2012 BCS game, and at least one or two teams inevitably make it from the unexpected.
The favorites to date are the Oklahoma Sooners, LSU Tigers, Alabama Crimson Tide, FSU Seminoles and Oregon Ducks. For purposes of intrigue and compelling content, none of them will be on this list of possible BCS teams because their inclusion on such a list is given.
This is a list of 10 potential long, but not too long, shots to crack the BCS when the calendar flips to 2012.


text:
- Report: #1038265
Report - Rebuttal - Arbitrate
Complaint Review: AmericaRx
AmericaRxInternet United States of America
AmericaRx I ordered though Amazon. According to Amazon this item was supposed to be shipped by Wednesday from AmericaRx. Because I noticed they were charging me $25 on a $44 order, I requested they cancel the, Internet
*Author of original report: Clarification
Ripoff Report
About you?
Ripoff Report
A business' first
line of defense
on the Internet.
If your business is
willing to make a
commitment to
customer satisfaction
Click here now..
Does your business have a bad reputation?
Fix it the right way.
Corporate Advocacy Program™
will never do business with them again. Also, their web address seems to have moved, which is not surprising given all the other complaints Ive run across on the web about them.
This report was posted on Ripoff Report on 03/26/2013 05:10 PM and is a permanent record located here: http://www.ripoffreport.com/r/AmericaRx/internet/AmericaRx-I-ordered-though-Amazon-According-to-Amazon-this-item-was-supposed-to-be-shipp-1038265. The posting time indicated is Arizona local time. Arizona does not observe daylight savings so the post time may be Mountain or Pacific depending on the time of year.
Ripoff Report has an exclusive license to this report. It may not be copied without the written permission of Ripoff Report.
Click Here to read other Ripoff Reports on AmericaRx
If you would like to see more Rip-off Reports on this company/individual, search here:Search Tips
In order to assure the best results in your search:
- Keep the name short & simple, and try different variations of the name.
- Do not include ".com", "S", "Inc.", "Corp", or "LLC" at the end of the Company name.
- Use only the first/main part of a name to get best results.
- Only search one name at a time if Company has many AKA's.
#1 Author of original report
AUTHOR: Charles 34 - ()
SUBMITTED: Tuesday, March 26, 2013POSTED: Tuesday, March 26, 2013
Are you an owner, employee or ex-employee with either negative or positive information about the company or individual, or can you provide "insider information" on this company?
Advertisers above have met our
strict standards for business conduct.


text:
- Report: #6272
Report - Rebuttal - Arbitrate
Complaint Review: GGW VIDEO
GGW VIDEODon't Know, California U.S.A.
GGW VIDEO - Girls Gone Wild rip-off
FOX 6 investigative reporter John Mattes first broke the story how Girls Gone Wild was marketing videos for only $9.99 consumers found the company tacking on huge fees. Thousands of consumers called it a rip-off on ripoffreport. After our story aired an attorney sued calling it deceptive advertising. Video part 1 Video part 2
Ripoff Report
About you?
Ripoff Report
A business' first
line of defense
on the Internet.
If your business is
willing to make a
commitment to
customer satisfaction
Click here now..
Does your business have a bad reputation?
Fix it the right way.
Corporate Advocacy Program™
Here is the contact information GGW VIDEO 323-965-8710 , CA
This report was posted on Ripoff Report on 08/21/2001 12:00 AM and is a permanent record located here: http://www.ripoffreport.com/r/GGW-VIDEO/Dont-Know-California/GGW-VIDEO-Girls-Gone-Wild-rip-offFOX-6-investigative-reporter-John-Mattes-first-broke-th-6272. The posting time indicated is Arizona local time. Arizona does not observe daylight savings so the post time may be Mountain or Pacific depending on the time of year.
Ripoff Report has an exclusive license to this report. It may not be copied without the written permission of Ripoff Report.
Click Here to read other Ripoff Reports on GGW VIDEO
If you would like to see more Rip-off Reports on this company/individual, search here:Search Tips
In order to assure the best results in your search:
- Keep the name short & simple, and try different variations of the name.
- Do not include ".com", "S", "Inc.", "Corp", or "LLC" at the end of the Company name.
- Use only the first/main part of a name to get best results.
- Only search one name at a time if Company has many AKA's.
Advertisers above have met our
strict standards for business conduct.


text:
Important delivery notice
The products on this site are only delivered to UK addresses. If you require delivery to another country please visit one of our other sites below.
Climbing Seeds & Plants
Sign up to our newsletter
In this impressive range of plants and seeds you'll find all manner of climbers from old favourites to more unusual varieties. They're perfect for covering walls, fences and sheds and many of them will fill your garden with a delightful scent.
added to your basket.
Sweet Pea 'Eleanore Udall'
A pretty new form with graduated pink petals and a heavenly scent ideal for garden display and home-made cut flower bouquets. We've developed this strain to help raise funds for our nominated charity of the year in 2016, Thrive.
Thrive is the leading charity that operates in the field of disability and gardening. It uses gardening to bring about positive changes in the lives of people who are living with disabilities or ill health, or are isolated, disadvantaged or vulnerable. This is known as social and therapeutic horticulture (STH). For more information visit www.thrive.org.uk
Sweet Pea 'Eleanore Udall' has been named after the wife of the founder of Thrive, Geoffrey Udall, who bequeathed his Beech Hill estate near Reading, Berkshire now home to the charity's head office and gardens. Height: 1.8m (6'). Spread 30cm (12").
50% of the money generated from each sale of Sweet Pea 'Eleanore Udall' will go to Thrive - our charity of year 2016. To find out more about our relationship with Thrive view our blog here. More info
Copyright © Thompson & Morgan, 2004-2016. All rights reserved.


text:
Welcome to our Website
Shagun Creation has made dominant mark for itself in the Fashion industry with its exclusive range of Apparels. Based in Delhi, the company is known as one of the eminent Manufacturers, Exporters, and Suppliers of exclusive Ladies Wear, Imitation Jewellary, Bollywood Replica Suits, Ladies Purse, Mens Wear and Kids Wear. While designing the products, we pay utmost attention towards the changing tastes of modern people as well as market trends across the globe. Maintaining higher quality standards in all the products is our priority and of course the minimum price of these products helps us to reach the women across the globe, who loves Indian fashion wear.
|Mobile No. +91-9899727279 / 9312250181 Call Us 08049671332
Home | About Us | Products | Contact Us | Enquiry | Site Map
All Right Reserved Shagun Creation
Premium Member of ExportersIndia.Com


text:
Separate multiple email addresses with a comma.
Note: Your message must be entered as plain text. Special characters, formatting, and HTML code are not supported.
Executive Education
Alumni HUB,
Events, Resources
Recruiting, Partnerships,
Executive Education
Profiles, Centers,
Fields of Study
Our Philosophy &
Zetlin-Jones, Ariel
Assistant Professor of Economics; BP Junior Faculty Chair AY 2016-2017
Email: email@example.com
Phone: 412-268-9743


text:
Vt quadriplegic awarded $43.1 million after crash
BURLINGTON A 51-year-old Vermont woman who was left a quadriplegic after the car she was driving was rear-ended almost six years ago has been awarded a $43.1 million jury verdict against the manufacturer of a car seat that allegedly collapsed during the crash.
The award against Johnson Controls Inc., of Milwaukee, is believed to be the largest civil verdict in state court in Vermont history.
Dzemila Heco, of Essex Junction, was injured Aug. 4, 2007, when the 2000 Dodge Neon she was driving was rear-ended. Hecos lawyers argued the car seat back collapsed, causing severe spinal cord injuries.
Heco was wearing a seat belt.
She will need 24-hour care for the rest of her life, her lawyer Bob Langdon told The Associated Press.
Although many hurdles need to be overcome before the case is over, any money the family recovers will be put into a trust to care for Dzemila, lawyer Robin Curtiss told the Burlington Free Press.
A spokesman for Johnson Controls said the company is considering an appeal.
Johnson Controls disagrees with the jurys conclusions, spokesman Fraser Engerman said in a statement. We believe that the seat was not at fault. Its design significantly exceeded all government and industry safety standards, as well as Chryslers own specifications. Johnson Controls stands behind the safety of all of its products.
The jury award included more than $620,000 for past medical bills, $26.5 million for future medical bills and health care expenses, more than $355,000 for past loss of income, more than $1.2 million for future loss of income, and $14.3 million for pain and suffering.
Curtiss said Heco is a refugee from Bosnia who escaped Sarajevo with two sons after her husband was killed. They arrived in Vermont in 1995.MORE IN Vermont NewsThe Vermont Supreme Court ruled Friday that brush-hogging a field does not earn an agricultural... Full StoryWASHINGTON Hiring has been strong in the past year in many presidential campaign swing states, ... Full StorySALT LAKE CITY The utopic communities envisioned by a wealthy Mormon businessman near religious... Full Story
- Most Popular
- Most Emailed


text:
Blood Root Valley
Tai-Chi in the Greenbelt
Sunday, June 23, 2013
10:00 a.m.–11:30 a.m.
This event repeats every week on Sunday between 4/7/2013 and 6/30/2013.
Please note: This event has already taken place. Please use the Search options on the right to find upcoming events.
$13 for Greenbelt Conservancy members; $15 for non-members. Discounted pre-paid 10-week passes are available.
Event Organizer
Staten Island Greenbelt Conservancy
Contact Number
(718) 351-3450
Contact Email
Related Links
Additional Media
Directions to Blood Root Valley
Know Before You Go
Greenbelt Recreation Center
On Wednesday, August 24, 2016 starting at 3:30 p.m. the Greenbelt Recreation Center will be closed due to an error in the air conditioning system that required immediate attention. The building will reopen on Thursday, August 25, 2016 at 6:30 a.m. on a modified schedule. Please call (718) 667-3545 for more information.
Anticipated Completion: 08/25/2016
Blood Root Valley Weather
- Movies Under the Stars: Some Like It Hot
- Singin' Stories with Caroline Cutroneo
- Summer Sports Experience at Greenbelt
- Trail of the Month: End of Summer Trail Cleanup
- Living with Deer


text:
Now that Apple has released iOS 9.1, the Pangu iOS 9 jailbreak has been patched and those who want to jailbreak, have to stay on iOS 9.0.2. If you updated to iOS 9.1 because of the few new features and bug fixes, but still want a jailbreak, don't worry. There is a way to go back. Apple is still … [Read more...]
Pangu Seeds iOS 9 Jailbreak Tool v1.1.0 And Pangu 9.0.x Untether v1.1
The Pangu team has released a new version of their iOS 9 jailbreak tool. After several users reported that the tool was causing problems, the Pangu team first released a version 1.0.1 and have now pushed a v1.1.0 update. Version 1.1.0 includes several more fixes to make the jailbreaking process … [Read more...]
Enable Apple News App In Any Country, Here's How
Apple introduced a new app in iOS 9 called Apple News. A news curating app that lets you choose your favorite topics and presents you with the best news from around the world. However, the News app is currently only available for users in the United States. A simple trick to enable the News … [Read more...]
3 iPhone 6s Features That You Can Get On Your Older iPhone
Apple announced the new iPhone 6s and iPhone 6s Plus at a special event last month. They are now available for purchase and plenty of customers are already rocking it. It has a brand new 3D Touch (Force Touch) display, a 12 megapixel camera, 4K video recording, A9 processor and 2GB RAM. They also … [Read more...]
List Of Jailbreak Tweaks Compatible With iOS 9
Last Wednesday, the Pangu team released a working jailbreak for iOS 9/9.0.1 and 9.0.2. The release was very much unexpected as we were eagerly waiting for an iOS 8.4.1 jailbreak instead. Good timing too, as Apple could release iOS 9.1 any day now and that can make the current exploits used by the … [Read more...]
Pangu 9 v1.0.1 iOS 9 Jailbreak Tool Now Available With Bug Fixes
The Pangu team has released an updated version of their iOS 9 jailbreak tool and included some bug fixes. In the first release, several users faced problems whilst trying to jailbreak. Most of those errors have been fixed in Pangu 9 v1.0.1 for Windows. We listed down fixes for most of the … [Read more...]
How To Fix Pangu 9 iOS 9 Jailbreak Errors Such As Cydia Crashing And Others
It's been a few days since the release of the untethered iOS 9 jailbreak by the Pangu team. Their new Pangu 9 tool can jailbreak iOS 9, 9.0.1 and 9.0.2. We already have an easy to follow tutorial on how to jailbreak iOS 9/9.0.1/9.0.2. As with all first releases, the Pangu 9 v1.0.0 tool has some … [Read more...]
How To Jailbreak iOS 9 / 9.0.1 / 9.0.2 Untethered Using Pangu 9 For Windows
Now that Pangu has released a working iOS 9 jailbreak, you're probably getting ready to jailbreak your iPhone, iPad or iPod Touch. The brand new iOS 9 jailbreak by Pangu is compatible with all the iOS devices that can run iOS 9 and works with the latest iOS 9.0.2 firmware as well. If you're … [Read more...]
The State Of The iOS 9.0.2 / 9.0.1 / 9 Jailbreak For iPhone, iPad, iPod Touch [UPDATED]
Will there be a new untethered jailbreak for iOS 9, 9.0.1 or 9.0.2? When will it be released and who will be first, TaiG or Pangu or some other group? Apple has finally released iOS 9 and those who have already updated, will not be able to jailbreak. Apple patched the exploits used by the TaiG … [Read more...]
Pangu Releases iOS 9 Jailbreak For iPhone, iPod Touch, iPad [Download Now]
Boom! It's here guys. Pangu has released a working, untethered iOS 9 jailbreak. We haven't been hearing much from any of the jailbreak developers, looks like they were hard at work. Seems to us that they're not interested in the money as well. Pangu is the first to release an untethered jailbreak … [Read more...]


text:
Driving 2005 Honda Accord EX-L I-VTEC 2.4L Auto Part 1/2
What do you think about this video?
zedzero77: milan lucic
Lee L: Man.. You really like sayin "Milan".. Do you think you're in Italy by saying it so much?
jesussaves13: I think the i-VTEC got quieter because the engine was now a double overhead cam rather than a SOHC and other components were probably changed.
Steven Lebbing: Those Honda's are nice my cousin he has a 2003 or maybe it's a 04 Honda Accord Coupe 2.4 in server he got it new man those engine have a nice sound to them and it has over 65,000 miles on it he got it bread new so i think he has had it for like 10 or 11 years now he still has it well i did a cold start of it last night also i did a cold start on my uncle Honda CRV i beleave his a 2008 or 09 i know his is the 3th gen man both of those cars started right up in the cold those Honda's always start so well even that when it's really cold outside so if you wanna see them go to my channel Foosefan15
Finding Waldo: but i still laugh. lol :) not being mean, I just find it funny. haha
Finding Waldo: lol never had any issues from my vehicle, I have a 07 wrangler. works just fine. E-breaks is used in Emergencies when breaking with a pedal is not enough during close collisions. or occasionally Drifters and street racers. not really meant to be used just to park in a automatic. Manual Yes, Automatic no.
mercmilan06: Well automakers don't equip vehicles with them for the hell of it. The only thing preventing your vehicle from moving is the parking pawl in the transmission. They do fail...and your car may or may not roll down a hill and knock over the sign outside your high school. That didn't happen to me but one kid's car did do that...best to fasten the car down just in case if just to take stress off the tranny.
Finding Waldo: I laugh at people who use E-brake on automatics... I mean its a Automatic... -_-
BlahBiddyBlah890: Wow, something weird I spotted when you turned on the car... why didn't it chime?! :O Just wondering, doesn't it have a chime to it??
Zach Davis: I have an 06 and its not a bad car. The ride is very compliant and it doesnt follow dips in the road like other midsized sedans. I think the 7th gen Accord has my favorite interior of the time too. And lets not forget that awesome engine!
ianmattl: too much power!? no such thing do you mean the gas pedal is too sensitive?
mercmilan06: The 2.4L has plenty of power and it's pretty darn smooth too, nice transmission. The V6 engine isn't needed for comfortable highway cruising either...I really like these cars.
Jakeman21642: Never realized you had videos on this generation of accord! What do you think of the 4 cylinder model? After driving my friend's 3.0 sedan around yesterday I loved it but I feel like the 3.0 is too much power for me not to mention gas would probably be a bitch.
Jennifer Horan: Japanese people all drive stick.
Jennifer Horan: What is it with American's and their automatic car's?
Rolling Fanatics: K24 3
mercmilan06: I still liked the Milan better because it felt so much more substantial on the road and I liked the interior more. The Accord feels like a more high quality vehicle and it is faster, more fuel efficient, and has a more refined engine. The steering/handling on the Milan is more European feeling than the softly sprung Accord.
nemesis drifter: honda accord 03-07 are great I have a 2004 model had driven 219284 KM mileage I had the transmision problem but still its the best car I had
leerayray: Thank you for the reply. It's great to hear that the car is holding up nicely. This makes my decision much easier. :)
Driving 2005 Honda Accord EX-L i-VTEC 2.4L auto Part 1/2 5 out of 5


text:
I am trying to hack at an existing theme and have become stuck.
My blog has a horizontal top bar which is my main navigation. I have set the "depth" to 1 on this so that any sub-pages (or child pages as it were) do not display. In other words, only the parent pages of my blog appear in this top navigation.
When a user clicks on a specific parent page. I want all the child pages for that parent to appear in a vertical sidebar.
Can anyone let me know how I might do about doing this?
Thanks - the site is http://www.macmillan-academy.org.uk/staff_blogs/mrking


text:
More results for Rough Terrain Crane
Crane Trucks
grove cranes
Rough Terrain Cranes For Sale
Grove crane
mobil crane
crane mobile
All Terrain Crane
kato crane
rough terrain
tadano cranes australia
Rough Terrain Crane
Rough Terrain Cranes TADANO America Corporation TADANO America Corporation.
Tadano is the recognized world leader in the manufacturing of rough terrain cranes. Manufactured at our state of the art facilities in Takamatsu Japan Tadanos rough terrain cranes are proven to be safe reliable and productive. Access the full list of rough terrain specifications on our Resource page!
Rough Terrain Grove.
Rough terrain cranes with lifting capacity from 35 to 80 tons Manotti.
Full range with capacities from 35 to 85 tons. The basic rough terrain crane made by Manotti consists of a frame complete with axles mounting the four drive wheels a rotating superstructure usually placed centrally to the frame and a telescopic arm hinged to the superstructure which also mounts the operators cab and the counterweight. Lifting capacity Boom length Maximum lifting height. 35 metric tons x 25 m. 89 m 266 m. 45 metric tons x 3 m.
Rough Terrain Cranes Construction Equipment.
The GRT8100 and GRT880 rough-terrain cranes replace the RT890E and RT880E respectively. XCMG RT70U Rough Terrain Crane. The RT70U rough-terrain crane is equipped with a two-axle off-road undercarriage. SANY SRC885 Rough-Terrain Crane. Sany expands its line of rough-terrain cranes with the SRC885 rated at 85 tons lifting capacity at a 10-foot radius. Link-Belt RTC-80110 Series II Rough Terrain Crane. Link-Belt 110-ton RTC-80110 Series II rough terrain crane has a full power boom fabricated from ultra-high-strength steel. Grove RT9150E Rough Terrain Crane.
Rough-Terrain Cranes.
lifting capacities from 30 to 80 tons. TADANO Rough-Terrain Cranes allow for safe operation by monitoring the crane operation and control overload area lifting by an advanced crane operating system and the AML-C device. The cranes are equipped with a rounded boom that was manufactured with cumulatively developed production technology. As environmentally conscious technology which was required recently TADANO Rough-Terrain Cranes are equipped with a monitoring function of fuel consumption Fuel Monitoring System a controlling system of maximum engine speed to reduce noise and fuel consumption Eco Mode System and an effective control system of hydraulic pump discharge Positive Control.
TADANO Rough Terrain Cranes.
Line Up Selector Select the region which you would like see the line up. Central / South America. Compact cranes with a single cab for both driving and lifting operation. This compact model has maneuverability capable of accessing to narrow spaces with all wheel steering and can be driven on rough or uneven terrain with all wheel driving.
TADANO Rough Terrain Cranes GR-600EX.
Rough Terrain Crane GR-600EX. Primary Features and Benefits. Automatic moment limiter AML-C. Control of asymmetric extension width of outriggers.
Beam and Dolly Transporters. Tower Cranes Hoists My Bigge. About Bigge Careers News Events Media Gallery Bigge Blog Contact Us Worldwide Shipping 1 888 337-2444. Menu Locations Call 1 888 337-2444. For International Crane Sales. and Nationwide Crane Rental call. 1-888-337-BIGGE Get the Bigge Newsletter Subscribe. Boom Trucks Carry Decks.
Contact Us


text:
Herald staff
ARLINGTON — Two men were arrested early Monday morning for investigation of breaking into several unlocked cars in the Gleneagle neighborhood of Arlington, police said.
The Everett men, 37 and 32, were booked into the Snohomish County Jail for investigation of theft and vehicle prowling.
Police received a call around 12:40 a.m. Monday from a neighbor who reported seeing two men walking near the Gleneagle Clubhouse.
Police believe that the vehicles were unlocked. Items such as GPS units, medication, checkbooks, CDs and iPods were taken and later recovered by police.
"These thefts were crimes of opportunity," Arlington Police Chief Nelson Beazley said. "We were fortunate that a vigilant neighbor reported the suspicious activity that led to the arrest of these two suspects."
Beazley said the case serves as a reminder that people should remove valuables from their cars and lock the vehicles.
The police department asks potential victims of the thefts to call 911 to request an officer to take a report.


text:
'Saturday Night Live': Kanye West's SNL Performances (Video)
Kanye West was the musical guest on this weekend's installment of "Saturday Night Live." He was also the main reason to tune in.
You can watch West's performances on SNL here.
Check out this featured story on Speakeasy: 'Waiting for Superman': John Legend Performs the Theme Song


text:
THE STARR REPORT; Full Text of Findings Sent to Congress -- Part One of Thirteen
Published: September 12, 1998
WASHINGTON, Sept. 11— Following is the complete text of the report by the Independent Counsel, Kenneth W. Starr, on his investigation of President Clinton, which was made public yesterday by the House of Representatives:
As required by Section 595(c) of Title 28 of the United States Code, the Office of the Independent Counsel (''OIC'' or ''Office'') hereby submits substantial and credible information that President William Jefferson Clinton committed acts that may constitute grounds for an impeachment.
The information reveals that President Clinton:
*lied under oath at a civil deposition while he was a defendant in a sexual harassment lawsuit;
*lied under oath to a grand jury;
*attempted to influence the testimony of a potential witness who had direct knowledge of facts that would reveal the falsity of his deposition testimony;
*attempted to obstruct justice by facilitating a witness's plan to refuse to comply with a subpoena;
*attempted to obstruct justice by encouraging a witness to file an affidavit that the President knew would be false, and then by making use of that false affidavit at his own deposition;
*lied to potential grand jury witnesses, knowing that they would repeat those lies before the grand jury; and
*engaged in a pattern of conduct that was inconsistent with his constitutional duty to faithfully execute the laws.
The evidence shows that these acts, and others, were part of a pattern that began as an effort to prevent the disclosure of information about the President's relationship with a former White House intern and employee, Monica S. Lewinsky, and continued as an effort to prevent the information from being disclosed in an ongoing criminal investigation.
Factual Background
In May 1994, Paula Corbin Jones filed a lawsuit against William Jefferson Clinton in the United States District Court for the Eastern District of Arkansas. Ms. Jones alleged that while he was the Governor of Arkansas, President Clinton sexually harassed her during an incident in a Little Rock hotel room. (3) President Clinton denied the allegations. He also challenged the ability of a private litigant to pursue a lawsuit against a sitting President. In May 1997, the Supreme Court unanimously rejected the President's legal argument. The Court concluded that Ms. Jones, ''like every other citizen who properly invokes [the District Court's] jurisdiction . . . has a right to an orderly disposition of her claims,'' and that therefore Ms. Jones was entitled to pursue her claims while the President was in office. A few months later, the pretrial discovery process began.
One sharply disputed issue in the Jones litigation was the extent to which the President would be required to disclose information about sexual relationships he may have had with ''other women.'' Ms. Jones's attorneys sought disclosure of this information, arguing that it was relevant to proving that the President had propositioned Ms. Jones. The President resisted the discovery requests, arguing that evidence of relationships with other women (if any) was irrelevant.
In late 1997, the issue was presented to United States District Judge Susan Webber Wright for resolution. Judge Wright's decision was unambiguous. For purposes of pretrial discovery, President Clinton was required to provide certain information about his alleged relationships with other women. In an order dated December 11, 1997, for example, Judge Wright said: ''The Court finds, therefore, that the plaintiff is entitled to information regarding any individuals with whom the President had sexual relations or proposed or sought to have sexual relations and who were during the relevant time frame state or federal employees.'' Judge Wright left for another day the issue whether any information of this type would be admissible were the case to go to trial. But for purposes of answering the written questions served on the President, and for purposes of answering questions at a deposition, the District Court ruled that the President must respond.
In mid-December 1997, the President answered one of the written discovery questions posed by Ms. Jones on this issue. When asked to identify all women who were state or federal employees and with whom he had had ''sexual relations'' since 1986, the President answered under oath: ''None.'' For purposes of this interrogatory, the term ''sexual relations'' was not defined.
On January 17, 1998, President Clinton was questioned under oath about his relationships with other women in the workplace, this time at a deposition. Judge Wright presided over the deposition. The President was asked numerous questions about his relationship with Monica Lewinsky, by then a 24-year-old former White House intern, White House employee, and Pentagon employee. Under oath and in the presence of Judge Wright, the President denied that he had engaged in a ''sexual affair,'' a ''sexual relationship,'' or ''sexual relations'' with Ms. Lewinsky. The President also stated that he had no specific memory of having been alone with Ms. Lewinsky, that he remembered few details of any gifts they might have exchanged, and indicated that no one except his attorneys had kept him informed of Ms. Lewinsky's status as a potential witness in the Jones case.
The Investigation