10 More Discussions You Might Find Interesting
1. Solaris
Hi
I have a pool name yuk-pool and its associated pset is yuk-pset. It has a min value is 20 and max value is 56. But size field has 48 value . This same pool is assign to 4 local zones. Whenever Cpu usage is high on one local zone it impact the cpu usage at other local zone as well during high... (1 Reply)
Discussion started by: sb200
1 Replies
2. Programming
Hi
on multi-core system - I know I can set each process to run on specific core (Processor Affinity).
If I want to set process (which contains several threads) to run on group of core, how can I do it ?
For example:
If we have 8 core,
and two process each process contain 4 threads.
And I... (2 Replies)
Discussion started by: laro1983
2 Replies
3. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
4. Solaris
First of all I'm new to solaris. Today is the first day i'm practicing zones.
In global zone i have created a two separate pools of 2CPU's and created a email-zone and a web-zone as given in a PDF. I deleted the 2 zones in the processor sets. How can i destroy the processor set and i want my... (2 Replies)
Discussion started by: breaker64
2 Replies
5. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
6. Shell Programming and Scripting
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Discussion started by: gregrobinsonhd
7 Replies
7. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
8. AIX
Guys...
Hows it going???
I have been going through the hardware spec of IBM system p systems.. and here i am confused
for IBM Power 520 Express it says
Processor cores:
One, two or four 64-bit 4.2 GHz POWER6 with AltiVec™ SIMD and Hardware Decimal Floating-Point acceleration
... (1 Reply)
Discussion started by: balaji_prk
1 Replies
9. UNIX for Advanced & Expert Users
Hi All,
I needed to get the result of two sqlplus queris into shell variables.
After days of looking for the ultimate solution to this problem.. i found this...
sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ",
$1);}' | read VAR1 VAR2
set head off... (2 Replies)
Discussion started by: pranavagarwal
2 Replies
10. AIX
Question is on setting of Physical and Virtual processors for LPARs to make proper use of virtualization capabilities.
Environment is a 8-way p570 with 4 LPARs.
lparVIO1 and lparVIO2:
AIX 5300-04-01
Mode/Type= Shared-SMT/Capped
Minimum Processors= 0.10
Desired Processors= 0.50
Maximum... (1 Reply)
Discussion started by: guttew
1 Replies
poolcfg(1M) poolcfg(1M)
NAME
poolcfg - create and modify resource pool configuration files
SYNOPSIS
/usr/sbin/poolcfg -c command [-d | [filename]]
/usr/sbin/poolcfg -f command_file [-d | [filename]]
/usr/sbin/poolcfg -h
The poolcfg command provides configuration operations on pools and sets. These operations are performed upon an existing configuration and
take the form of modifications to the specified configuration file. If you use the -d option, the modifications occur to the kernel state.
Actual activation of the resulting configuration is achieved by way of the pooladm(1M) command.
Pools configuration files are structured files that must have been constructed using poolcfg itself or libpool(3LIB) directly.
The configurations which are created by this tool can be used by pooladm to instantiate the configuration upon a target host.
The following options are supported:
-c command Specify command as an editing command. See USAGE.
-d Operate directly on the kernel state. No filename is allowed.
-f command_file Take the commands from command_file. command_file consists of editing commands, one per line.
-h Display extended information about the syntax of editing commands.
Scripts
A script consists of editing commands, one per line, of the following:
info [entity-name]
Display configuration (or specified portion) in human readable form to standard output. If no entity is specified, system information
is displayed. Therefore, poolcfg -c 'info' afile is an equivalent invocation to poolcfg -c 'info system name' afile.
create entity-name [property-list]
Make an entity of the specified type and name.
destroy entity-name
Remove the specified entity.
modify entity-name [property-list]
Change the listed properties on the named entity.
associate pool-name [resource-list]
Connect one or more resources to a pool, or replace one or more existing connections.
transfer to [resourcetype] name [component-list]
Transfer one or more discrete components to a resource .
transfer [quantity] from [resourcetype] [src] to [tgt]
Transfer a resource quantity from src to tgt .
transfer [quantity] to [resourcetype] [tgt] from [src]
Transfer a resource quantity to tgt from src.
discover
Create a system entity, with one pool entity and resources to match current system configuration. All discovered resources of each
resource type are recorded in the file, with the single pool referring to the default resource for each resource type.
This command is a NO-OP when poolcfg operates directly on the kernel. See the -d option.
You should avoid use of this command. The preferred method for creating a configuration is to export the dynamic configuration using
pooladm(1M) with the -s option.
rename entity-name to new-name
Change the name of an entity on the system to its new name.
Property Lists
The property list is specified by:
( proptype name = value [ ; proptype name = value ]* )
where the last definition in the sequence for a given proptype, name pair is the one that holds. For property deletion, use ~ proptype
name.
Resource Lists
A resource list is specified by:
( resourcetype name [ ; resourcetype name ]* )
where the last specification in the sequence for a resource is the one that holds. There is no deletion syntax for resource lists.
Component Lists
A component list is specified by:
( componenttype name [ ; componenttype name ]* )
where the last specification in the sequence for a resource is the one that holds. There is no deletion syntax for component lists.
Recognized Entities
system Machine level entity
pool Named collection of resource associations
Resource Types
pset Processor set resource
Property Types
boolean Takes one of two values true or false.
int A 64-bit signed integer value.
uint A 64-bit unsigned integer value.
string Strings are delimited by quotes ("), and support the character escape sequences defined in formats(5).
float Scientific notation is not supported.
Example 1: Writing a poolcfg Script
The following poolcfg script creates a pool named Accounting, and a processor set, small-1. The processor set is created first, then the
pool is created and associated with the set.
create pset small-1 ( uint pset.min = 1 ; uint pset.max = 4)
create pool Accounting
associate pool Accounting ( pset small-1 )
Example 2: Reporting on pool_0
The following command reports on pool_0 to standard output in human readable form:
# poolcfg -c 'info pool pool_0' /etc/pooladm.conf
Example 3: Destroying pool_0 and Its Associations
The following command destroys pool_0 and associations, but not the formerly associated resources:
# poolcfg -c 'destroy pool pool_0' /etc/pooladm.conf
Example 4: Displaying the Current Configuration
The following command displays the current configuration:
$ poolcfg -c 'info' /etc/pooladm.conf
system example_system
int system.version 1
boolean system.bind-default true
string system.comment Discovered by libpool
pool pool_default
boolean pool.default true
boolean pool.active true
int pool.importance 5
string pool.comment
string.pool.scheduler FSS
pset pset_default
pset pset_default
int pset.sys_id -1
string pset.units population
boolean pset.default true
uint pset.max 4294967295
uint pset.min 1
string pset.comment
boolean pset.escapable false
uint pset.load 0
uint pset.size 2
cpu
int cpu.sys_id 0
string cpu.comment
cpu
int cpu.sys_id 2
string cpu.comment
Example 5: Moving cpu with ID 2 to Processor Set pset1 in the Kernel
The following command moves cpu with ID 2 to processor set pset1 in the kernel:
# poolcfg -dc 'transfer to pset pset1 ( cpu 2 )'
Example 6: Moving 2 cpus from Processor Set pset1 to Processor Set pset2 in the Kernel
The following command moves 2 cpus from processor set pset1 to processor set pset2 in the kernel:
# poolcfg -dc 'transfer 2 from pset pset1 to pset2'
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpool |
+-----------------------------+-----------------------------+
|Interface Stability |See below. |
+-----------------------------+-----------------------------+
The invocation is Evolving. The output is Unstable.
pooladm(1M), poolbind(1M), libpool(3LIB), attributes(5), formats(5)
15 Feb 2005 poolcfg(1M)