Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

fbsql_db_status(3) [php man page]

FBSQL_DB_STATUS(3)							 1							FBSQL_DB_STATUS(3)

fbsql_db_status - Get the status for a given database

SYNOPSIS
int fbsql_db_status (string $database_name, [resource $link_identifier]) DESCRIPTION
Gets the current status of the specified database. PARAMETERS
o $database_name - The database name. o $ link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect(3) was called with no arguments. RETURN VALUES
Returns an integer value with the current status. This can be one of the following constants: o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database by using a port number. FBExec can be available on the server but no connection has been made for it. o FBSQL_UNKNOWN - The Status is unknown. o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database. o FBSQL_STARTING - The database is starting. o FBSQL_RUNNING - The database is running and can be used to perform SQL operations. o FBSQL_STOPPING - The database is stopping. o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database. SEE ALSO
fbsql_start_db(3), fbsql_stop_db(3). PHP Documentation Group FBSQL_DB_STATUS(3)

Check Out this Related Man Page

FBSQL_LIST_FIELDS(3)							 1						      FBSQL_LIST_FIELDS(3)

fbsql_list_fields - List FrontBase result fields

SYNOPSIS
resource fbsql_list_fields (string $database_name, string $table_name, [resource $link_identifier]) DESCRIPTION
Retrieves information about the given table. PARAMETERS
o $database_name - The database name. o $table_name - The table name. o $ link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect(3) was called with no arguments. RETURN VALUES
Returns a result pointer which can be used with the fbsql_field_xxx functions, or FALSE on error. ERRORS
/EXCEPTIONS A string describing the error will be placed in $phperrmsg, and unless the function was called as @fbsql() then this error string will also be printed out. EXAMPLES
Example #1 fbsql_list_fields(3) example <?php $link = fbsql_connect('localhost', 'myname', 'secret'); $fields = fbsql_list_fields("database1", "table1", $link); $columns = fbsql_num_fields($fields); for ($i = 0; $i < $columns; $i++) { echo fbsql_field_name($fields, $i) . " ";; } ?> The above example will output something similar to: field1 field2 field3 SEE ALSO
fbsql_field_len(3), fbsql_field_name(3), fbsql_field_type(3), fbsql_field_flags(3). PHP Documentation Group FBSQL_LIST_FIELDS(3)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help on processes not associated with a TTY

Hi all ^_^ Okay, here's the problem: There's an IBM RS6000 server running AIX 4.3 with Informix database in my workplace. During peak hours, it has about 350 users doing mostly database operations. It has been set up that those users can only log-in the system at one terminal at a time. Due... (3 Replies)
Discussion started by: bluefactory
3 Replies

2. AIX

connect SQLSERVER from unix

I have an application working in unix accessing oracle 9i database on a IBM AIX Unix 5.2 system. I want this unix application to retrieve data from a SQL server 2000 server to oracle database. how can i connect to this SQL server database from a unix application pls help me if you can (2 Replies)
Discussion started by: samsonsimon
2 Replies

3. UNIX for Advanced & Expert Users

create database on unix

how can i create database on unix from command line (without using DBCA) (2 Replies)
Discussion started by: gfhgfnhhn
2 Replies

4. HP-UX

UNIX memory problems

I don't know if this is better suited for the application section, but here goes. We are currently running HP-UX 11 as our database server. The database is Progress version 9.1C. As of late, some of our batch processes that run on the UNIX db server are erroring out because of what appear to... (3 Replies)
Discussion started by: eddiej
3 Replies

5. Infrastructure Monitoring

visual representation of server health

HI all, I want to make a webpage showing the status of services running on a server. for example email, http , etc. That way users can see that server status for themselfs. Maybe even show the status of each virtual domain running on the server. Any way to do this without buying some product? ... (4 Replies)
Discussion started by: mcraul
4 Replies

6. Shell Programming and Scripting

How to assign the specific value

Hi Everyone, How to assign the specific value which return from database? here is the return value from database --> (return status = 0) 0 <----- this I only need to get the "0" .. assign to another declare variable. hope someone will help me.. Please thank you.. (4 Replies)
Discussion started by: ryanW
4 Replies

7. Shell Programming and Scripting

Moving a database from one server to another

I hope I'm posting this in the correct section. I'm trying to move a database from one server to another. This is the code I'm using... tar czf - vbdatabase.sql | ssh username@full.domain.com 'cat > /home/cpanelusername/vbdatabase.tar.gz ... but all I'm getting is a ">" and then nothing... (4 Replies)
Discussion started by: Chimpie
4 Replies

8. IP Networking

Network Tweaking - Database Query Across Internet

Hi We run a script that queries a database via the internet and we need the fast possible connections to the database server. I have centos server which sends the requests to the database across the internet . it sends upto 800 queries per milliseconds however this using the default... (4 Replies)
Discussion started by: um08
4 Replies

9. Hardware

Raid 0 on database server

Hi guys. if we want to use SSD drives on a database server, can we use RAID 0 configuration because of their reliability? (3 Replies)
Discussion started by: majid.merkava
3 Replies

10. Shell Programming and Scripting

loop picks up password for 2 entry...how to avoid that ?

hello all, i am trying to find a better to do what i am doing right now... i have a file called sidlist...which has my database_name and password to the respective database so something like below.. file is called sidlist and entry is below... test, abc123 kes12, abcd12 pss, abcd1234... (5 Replies)
Discussion started by: abdul.irfan2
5 Replies

11. AIX

Performance issue

Hi, We have 2 lpars on p6 blade. One of the lpar is having 3 core cpu with 5gb memory running sybase as database. An EOD process takes 25 min. to complete. Now we have an lpar on P7 server with entitled cpu capacity of 2 with 16 Gb memory and sybase as database. The EOD process which takes... (17 Replies)
Discussion started by: vjm
17 Replies

12. Shell Programming and Scripting

Cron job and tty

Hi, I have a document oriented database. IF there are multiple instances of the same running, i kill all those and then start the server again. i check for multiple instances within a specific time intervel. i.e. i make use of crontab. now the server is getting restarted after the cronjob... (8 Replies)
Discussion started by: sarath@123
8 Replies

13. UNIX for Advanced & Expert Users

Question related to UNIX and Oracle DB

I have one application server, which is Solaris non global zone (dsapid02-dt3d02 - 10.63.76.96) and a database server, which is Linux (db1-serv26 - 10.63.36.117 & 10.63.36.118). Whenever database admin is starting listener, it starts filling listener log file. Within minutes, it will make file in... (6 Replies)
Discussion started by: solaris_1977
6 Replies

14. Homework & Coursework Questions

Help fixing my database script

1. The problem statement, all variables and given/known data: I need help I get a variant of syntax errors when compiling my script to maintain a database. It's a simple database meant to create/view/maintain vehicles. 2. Relevant commands, code, scripts, algorithms: my if statements have... (5 Replies)
Discussion started by: gamernerd101
5 Replies

15. AIX

Need to check long running processes on the database server and the os is AIX

Hello, Please help me with a script with which I can check long running processes on the database server and the os is AIX. Best regards, Vishal (5 Replies)
Discussion started by: Vishal_dba
5 Replies