Tuesday, August 07, 2007

What an IMSI and PLMN is ?

IMSI

The IMSI (International Mobile Subscriber Identity) is a unique 15-digit code used to identify an individual user on a GSM network.

The IMSI consists of three components:
  • Mobile Country Code (MCC)
  • Mobile Network Code (MNC)
  • Mobile Subscriber Identity Number (MSIN)
The IMSI is stored in the Subscriber Identity Module (SIM).

PLMN

Short for Public Land Mobile Network, a generic term for a mobile wireless network that is centrally operated and administrated by an organization and uses land-based radio frequency transmitters or base stations as network hubs. PLMNs can stand alone and interconnect with one another or connect to a fixed system such as the PSTN.

Cellular phones and mobile Internet access are two common uses of a PLMN.

Friday, August 03, 2007

The log file for database is full. Back up the transaction log for the database to free up some log space.

Don't panic. This error inform that the log file for your SQL Server database is full. If you're playing with Classic ASP then the error message would be appear like this below:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'YOURDATABASENAME' is full. Back up the transaction log for the database to free up some log space.


To solve this problem simply open Query Analyzer and then run the command below:

BACKUP LOG yourdatabasename WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (yourdatabasename_log,0)
GO


Then, make sure that you have a backup schedule in place to prevent the log file growth from getting out of hand. Backup the database, and then shrink the transaction log to free up log space.

You can setup a new maintenance plan. Go into Enterprise Manager -> Management, right click on Maintenance plan and choose New Maintenance plan.