Following Tools can be used to Monitor the application jobs.

JobScape
Unicenter Enterprise Job Manager - Web Console
Unicenter Workload Control Center - Web Console
JAWS
iXP
Autosys Web Interface

Additionally Contact Computer Associates for further 
information regarding the Licencing.

sybase.com
infocenter.sybase.com
 except this sites

Hi, Try to register yourself as a user at the following 
link and try your luck.

https://login.sybase.com/login/userLogin.do?referer=http%3A%
2F%2Fdownloads.sybase.com%2Fswd%2Fbase.do

One more link where you can find a good material is

http://www.sypron.nl/main.html

Any table with name starting with '#' is automatically put 
into tempdb database.
Temp tables allow developers to create and scan tables 
within a stored procedure - and
have the tables totally isolated from all other database 
connections. This is very
valuable when results need to be processed several times 
within a loop, or when
a complex result set is expected (like a crosstab). Note 
that temp table transactions
are logged within tempdb (exception: select into create 
statements).

temp table is a temporary table,any user can use this 
temptable,it is one of the required database

Hi, This answer is with respect Sybase ASE database

# temp-table

A temp table is created with a prefix of #. These are 
session specific. That means if user-1 creates some temp 
tables with #<some name> and logs out and then logs-in into 
the database, he will not be able to see the #<table> which 
he created.

Shareable temp-table

In turn, if the user creates tables in tempdb without 
any "#" , then the table becomes shareable temp table. 
These will remain in tempdb till the ASE is rebooted. If 
the user logs-out and then logs-in , even in second 
sessioin he can still access these table.

- Pavan

To know what is Sybase please read the web-page at 
following link

http://www.sypron.nl/whatis_ase.html

To download Sybase ASE ( Developer edition ) which is free 
and very easy install, please visit the following link. 
Download "Sybase ASE 15.0 for Windows x86" if you OS is 
windows. Along with the download , the Sybase gives 
detailed instructions on how to install, learn and use the 
Sybase ASE.

http://www.sybase.com/ase_1500devel

PN: "Sybase ASE" is the database name ; 15.0 is the 
version; windows x86 is what you want as you have a windows 
OS on your PC.

- Pavan

Yes, it’s possible that we can login to one database with 
corresponding user id. Because we can have multiple users 
associated to same login, each corresponds to different 
database, so 
We can login to one database with corresponding user id by 
issuing command from command prompt
is : isql –U_user id –P_password –D database_name

When you install Adaptive Server, it contains these system 
databases:

The master database controls the user databases and the 
operation of Adaptive Server as a whole. It stores 
information about all user databases and their associated 
database devices.

The model database is used by Adaptive Server as a template 
for creating new user databases.
	A new database cannot be smaller than the model 
database.

? The sybsystemprocs database contains the system stored 
procedures.

The sybsystemdb database contains information about 
distributed transactions.

? The temporary database, tempdb, stores temporary objects, 
including temporary tables created with the name 
prefix ?tempdb..?.

? The sybsecurity database, contains the audit system for 
Adaptive Server. It consists of:

The system tables, sysaudits_01, sysaudits_02, ... 
sysaudits_08, which contain the audit trail
The sysauditoptions table, which contains rows describing 
the global audit options.
All other default system tables that are derived from model

Databases per Adaptive Server Enterprise -	32,767 
Server Size 	- 8 terabytes
Database size 	- 4 terabytes 
Page Size 	- 2K, 4K, 8K, 16K
Databases spanned by one update 	16 
Databases opened by one transaction 	16
Tables in a query 			50 
Logins per server 		2,147,516,416
Users per database 		2,146,484,223 
Groups per database 		1,032,193
Columns per table 			1024 
Arguments to stored procedure 		2048

The Sybase Server 
A Sybase server consists of: 
       a) Two processes, data server and backup server.
       b) Devices which house the databases; one database 
(master) contains system and configuration data.
       c) A configuration file which contains the server 
attributes. 
Memory Model 
The Sybase memory model consists of: 
	a) The program area, which is where the dataserver 
executable is stored.
	b) The data cache, stores recently fetched pages 
from the database device. 
	c) The stored procedure cache, which contains 
optimized sql calls. 
A database device stores the objects that make up 
databases. 
	The term device does not necessarily refer to a 
distinct physical device: it can refer to any piece of a 
disk (such as a disk partition) or a file in the file 
system that is used to store databases and their objects.

Each database device or file must be prepared and made 
known to Adaptive Server before it can be used for database 
storage. This process is called initialization.
A segment is a label that points to one or more database 
devices. When you first create a database, Adaptive Server 
creates three segments in the database,

System: Stores the database?s system tables.
Logsegment: Stores the database?s transaction log.
Default: Stores all other database objects?unless you 
create additional segments and store tables or indexes on 
the new segments by using create table...on segment_name or 
create index...on segment_name

use tempdb
go
sp_helpsegment "default"
go

Do any of the following 
1. restart the sybase database server
2. alter the size of the tempdb

If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use

select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by 
confirming with the concern users.
Restarting the server is not recommanded.

lct_admin (0,2) would abort all open transactions, or you 
can go for altering the tempdb space. Multiple tempdb's is 
a feature which can be implemented to minimize such issues 
of tempdb getting full.

if the system temp db gets filled, even sa cannot get 
connected to that temp db  to check which processes are 
blocking, in order to avoid this , a good concept of 
multiple temp dbs can be implemented and we can create temp 
dbs and assign newly created temp db to sa, so that sa 
could get the info of the processes that is blocking temp 
db, ab=nd by using lct_admin or some other commands we can 
abort that blocking transaction.

use tempdb
go
sp_helpsegment "default"
go

If the transaction log of tempdb is full then you call 
login through sa and type following command.
> dump tran tempdb with trancate_only
> go

If the database is full then you can increase the size of 
the database on a free device.
> alter database tempdb on device_name = size
> go