12-22-2010
Breaking a Big VG with Factor 3 does not look like thorough planning... With such a 'naturally' grown VG you must be prepared to take into consideration that sth. in the VG/LV structure simply broke especially if that was not a Big VG right from the beginning. What you should do: run a
# varyonvg sybasevg01
then try extending the LV again.
What you could do if it still fails after the varyonvg: change sth. in the LV properties to rewrite the VGDAs e.g. change the inter-policy from minimum to maximum
# chlv -ex -u42 -x1856 <yourlv>
and try the extension again.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi!
I have a script shell and I must do a calculation:
let c=7/4
echo $c => 1 :(
and me I want 1,75
Is it possible to find 1,75 in shell?
Thinks! (10 Replies)
Discussion started by: Castelior
10 Replies
2. UNIX for Advanced & Expert Users
I Use mkcd for save same directories into DVD, But the commande not complete succefuly
mkcd -r directorie_i_whish_save -d /dev/cd1
please it is very urgent
thank you :confused: :confused: (1 Reply)
Discussion started by: mktahar
1 Replies
3. AIX
I can write into DVD? I have USE "MKCD" command
mkcd -r directorie -d /dev/cd1
please help me it s urgent (2 Replies)
Discussion started by: mktahar
2 Replies
4. IP Networking
I have a system that i want to reach via a vpn created vi a fierwall.The fierwall in an other system.
The ip i am trying to get to is 172.16.4.48
I need to get to it via the hme1 interface.
The vpn gateway has this ip 172.30.50.1
I need to clean up the routing table and make this work; or is it... (5 Replies)
Discussion started by: waterboy
5 Replies
5. UNIX for Advanced & Expert Users
Hi,
I want to create a new environment variable (JAVA_HOME), but when I open a new shell this varible is delete...
to create the variable I do :
export JAVA_HOME=/usr/java/jdk
and I verify with :
echo $JAVA_HOME
and it's work...
But When I open a new shell this variable is forget...
( It... (2 Replies)
Discussion started by: marcel_kobain
2 Replies
6. Filesystems, Disks and Memory
hi
i'm trying to mount my usb device in fedora 7(vmware)
i use the comand:
mount /sda1 /mnt
but when i go to /mnt i find the content of the folder /boot.
can u tell me what's the problem? (2 Replies)
Discussion started by: jalil smail
2 Replies
7. Solaris
Bonjour,
J'ai ajouté par erreur à un sous mirroir des disques de cette facon :
metattach d53 c2t90d0s0 c2t90d1s0 ... alors que j'aurais du faire un stripe par disque (comme ça) :
metattach d53 c2t90d0s0
metattach d53 c2t90d1s0
..
Derriere, j'ai fais un growfs -M du FS pour l'aggrandir et... (1 Reply)
Discussion started by: phil.nakache
1 Replies
8. Linux
bonjour,
j'ai un serveur Linux ayant 2 interfaces eth0 et eth1. j'ai configuré deux adresses IP de deux réseaux différents sur les 2 interfaces, et je les ai connecté sur 2 commutateurs différents.
l'adresse IP de eth0 répond sans problème au ping des équipement de son réseau d'appartenance, malheureusement cela... (1 Reply)
Discussion started by: cerco
1 Replies
LEARN ABOUT PHP
pdostatement.bindparam
PDOSTATEMENT.BINDPARAM(3) 1 PDOSTATEMENT.BINDPARAM(3)
PDOStatement::bindParam - Binds a parameter to the specified variable name
SYNOPSIS
public bool PDOStatement::bindParam (mixed $parameter, mixed &$variable, [int $data_type = PDO::PARAM_STR], [int $length], [mixed
$driver_options])
DESCRIPTION
Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was used to prepare the statement.
Unlike PDOStatement.bindValue(3), the variable is bound as a reference and will only be evaluated at the time that PDOStatement.execute(3)
is called.
Most parameters are input parameters, that is, parameters that are used in a read-only fashion to build up the query. Some drivers support
the invocation of stored procedures that return data as output parameters, and some also as input/output parameters that both send in data
and are updated to receive it.
PARAMETERS
o $parameter
- Parameter identifier. For a prepared statement using named placeholders, this will be a parameter name of the form $:name. For a
prepared statement using question mark placeholders, this will be the 1-indexed position of the parameter.
o $variable
- Name of the PHP variable to bind to the SQL statement parameter.
o $data_type
- Explicit data type for the parameter using the PDO::PARAM_* constants. To return an INOUT parameter from a stored procedure, use
the bitwise OR operator to set the PDO::PARAM_INPUT_OUTPUT bits for the $data_type parameter.
o $length
- Length of the data type. To indicate that a parameter is an OUT parameter from a stored procedure, you must explicitly set the
length.
o $driver_options
-
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Execute a prepared statement with named placeholders
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < :calories AND colour = :colour');
$sth->bindParam(':calories', $calories, PDO::PARAM_INT);
$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #2
Execute a prepared statement with question mark placeholders
<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?');
$sth->bindParam(1, $calories, PDO::PARAM_INT);
$sth->bindParam(2, $colour, PDO::PARAM_STR, 12);
$sth->execute();
?>
Example #3
Call a stored procedure with an INOUT parameter
<?php
/* Call a stored procedure with an INOUT parameter */
$colour = 'red';
$sth = $dbh->prepare('CALL puree_fruit(?)');
$sth->bindParam(1, $colour, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 12);
$sth->execute();
print("After pureeing fruit, the colour is: $colour");
?>
SEE ALSO
PDO.prepare(3), PDOStatement.execute(3), PDOStatement.bindValue(3).
PHP Documentation Group PDOSTATEMENT.BINDPARAM(3)