Procedures

This section provides a complete reference to the Neo4j procedures.

1. Procedures, editions and modes

Available procedures depends on the type of installation you have:

  • Neo4j Enterprise Edition provides a larger set of procedures than Neo4j Community Edition.

  • Cluster members have procedures that are not available in standalone mode.

To check which procedures are available in your Neo4j instance, use the Cypher command SHOW PROCEDURES.

Example 1. List available procedures

To list the procedures available on your particular installation, run the following Cypher query:

SHOW PROCEDURES

2. List of procedures

Table 1. Neo4j procedures
Name

db.awaitIndex()

db.awaitIndexes()

db.checkpoint()

Enterprise Edition

db.clearQueryCaches()

db.constraints()

Deprecated

db.createIndex()

Deprecated

db.createLabel()

db.createNodeKey()

Enterprise Edition Deprecated

db.createProperty()

db.createRelationshipType()

db.createUniquePropertyConstraint()

Deprecated

db.index.fulltext.awaitEventuallyConsistentIndexRefresh()

db.index.fulltext.createNodeIndex()

Deprecated

db.index.fulltext.createRelationshipIndex()

Deprecated

db.index.fulltext.drop()

Deprecated

db.index.fulltext.listAvailableAnalyzers()

db.index.fulltext.queryNodes()

db.index.fulltext.queryRelationships()

db.indexDetails()

Deprecated

db.indexes()

Deprecated

db.info()

db.labels()

db.listLocks()

Enterprise Edition

db.ping()

db.prepareForReplanning()

db.propertyKeys()

db.relationshipTypes()

db.resampleIndex()

db.resampleOutdatedIndexes()

db.schema.nodeTypeProperties()

db.schema.relTypeProperties()

db.schema.visualization()

db.schemaStatements()

Deprecated

db.stats.clear()

db.stats.collect()

db.stats.retrieve()

db.stats.retrieveAllAnonymized()

db.stats.status()

db.stats.stop()

dbms.cluster.routing.getRoutingTable()

dbms.cluster.overview()

Enterprise Edition

dbms.cluster.protocols()

Enterprise Edition

dbms.cluster.quarantineDatabase()

Enterprise Edition

dbms.cluster.readReplicaToggle()

Enterprise Edition

dbms.cluster.role()

Enterprise Edition

dbms.cluster.setDefaultDatabase()

Enterprise Edition

dbms.components()

dbms.database.state()

dbms.functions()

Deprecated

dbms.info()

dbms.killConnection()

dbms.killConnections()

dbms.killQueries()

dbms.killQuery()

dbms.killTransaction()

dbms.killTransactions()

dbms.listActiveLocks()

dbms.listConfig()

dbms.listConnections()

dbms.listPools()

Enterprise Edition

dbms.listQueries()

dbms.listTransactions()

dbms.procedures()

Deprecated

dbms.quarantineDatabase()

Enterprise Edition

dbms.queryJmx()

dbms.routing.getRoutingTable()

dbms.scheduler.failedJobs()

Enterprise Edition

dbms.scheduler.groups()

Enterprise Edition

dbms.scheduler.jobs()

Enterprise Edition

dbms.scheduler.profile()

Enterprise Edition

dbms.security.activateUser()

Enterprise Edition Deprecated

dbms.security.addRoleToUser()

Enterprise Edition Deprecated

dbms.security.changePassword()

Deprecated

dbms.security.changeUserPassword()

Enterprise Edition Deprecated

dbms.security.clearAuthCache()

Enterprise Edition

dbms.security.createRole()

Enterprise Edition Deprecated

dbms.security.createUser()

Deprecated

dbms.security.deleteRole()

Enterprise Edition Deprecated

dbms.security.deleteUser()

Deprecated

dbms.security.listRoles()

Enterprise Edition Deprecated

dbms.security.listRolesForUser()

Enterprise Edition Deprecated

dbms.security.listUsers()

Deprecated

dbms.security.listUsersForRole()

Enterprise Edition Deprecated

dbms.security.removeRoleFromUser()

Enterprise Edition Deprecated

dbms.security.suspendUser()

Enterprise Edition Deprecated

dbms.setConfigValue()

Enterprise Edition

dbms.showCurrentUser()

Deprecated

dbms.upgrade()

dbms.upgradeStatus()

tx.getMetaData()

tx.setMetaData()

3. Procedure descriptions

Table 2. db.awaitIndex()

Description

Wait for an index to come online.

Example: CALL db.awaitIndex("MyIndex", 300)

Signature

db.awaitIndex(indexName :: STRING?, timeOutSeconds = 300 :: INTEGER?) :: VOID

Mode

READ

Table 3. db.awaitIndexes()

Description

Wait for all indexes to come online.

Example: CALL db.awaitIndexes(300)

Signature

db.awaitIndexes(timeOutSeconds = 300 :: INTEGER?) :: VOID

Mode

READ

Table 4. db.checkpoint() Enterprise Edition

Description

Initiate and wait for a new check point, or wait any already on-going check point to complete.

Note that this temporarily disables the dbms.checkpoint.iops.limit setting in order to make the check point complete faster. This might cause transaction throughput to degrade slightly, due to increased IO load.

Signature

db.checkpoint() :: (success :: BOOLEAN?, message :: STRING?)

Mode

DBMS

Table 5. db.clearQueryCaches()

Description

Clears all query caches.

Signature

db.clearQueryCaches() :: (value :: STRING?)

Mode

DBMS

Table 6. db.constraints() Deprecated

Description

List all constraints in the database.

Signature

db.constraints() :: (name :: STRING?, description :: STRING?, details :: STRING?)

Mode

READ

Table 7. db.createIndex() Deprecated

Description

Create a named schema index with specified index provider and configuration (optional).

Yield: name, labels, properties, providerName, status

Signature

db.createIndex(indexName :: STRING?, labels :: LIST? OF STRING?, properties :: LIST? OF STRING?, providerName :: STRING?, config = {} :: MAP?) :: (name :: STRING?, labels :: LIST? OF STRING?, properties :: LIST? OF STRING?, providerName :: STRING?, status :: STRING?)

Mode

SCHEMA

Table 8. db.createLabel()

Description

Create a label

Signature

db.createLabel(newLabel :: STRING?) :: VOID

Mode

WRITE

Table 9. db.createNodeKey() Enterprise Edition Deprecated

Description

Create a named node key constraint. Backing index will use specified index provider and configuration (optional).

Yield: name, labels, properties, providerName, status

Signature

db.createNodeKey(constraintName :: STRING?, labels :: LIST? OF STRING?, properties :: LIST? OF STRING?, providerName :: STRING?, config = {} :: MAP?) :: (name :: STRING?, labels :: LIST? OF STRING?, properties :: LIST? OF STRING?, providerName :: STRING?, status :: STRING?)

Mode

SCHEMA

Table 10. db.createProperty()

Description

Create a Property

Signature

db.createProperty(newProperty :: STRING?) :: VOID

Mode

WRITE

Table 11. db.createRelationshipType()

Description

Create a RelationshipType

Signature

db.createRelationshipType(newRelationshipType :: STRING?) :: VOID

Mode

WRITE

Table 12. db.createUniquePropertyConstraint() Deprecated

Description

Create a named unique property constraint.

Backing index will use specified index provider and configuration (optional).

Yield: name, labels, properties, providerName, status

Signature

db.createUniquePropertyConstraint(constraintName :: STRING?, labels :: LIST? OF STRING?, properties :: LIST? OF STRING?, providerName :: STRING?, config = {} :: MAP?) :: (name :: STRING?, labels :: LIST? OF STRING?, properties :: LIST? OF STRING?, providerName :: STRING?, status :: STRING?)

Mode

SCHEMA

Table 13. db.index.fulltext.awaitEventuallyConsistentIndexRefresh()

Description

Wait for the updates from recently committed transactions to be applied to any eventually-consistent full-text indexes.

Signature

db.index.fulltext.awaitEventuallyConsistentIndexRefresh() :: VOID

Mode

READ

Table 14. db.index.fulltext.createNodeIndex() Deprecated

Description

Create a node full-text index for the given labels and properties.

The optional 'config' map parameter can be used to supply settings to the index. Supported settings are 'analyzer', for specifying what analyzer to use when indexing and querying. Use the db.index.fulltext.listAvailableAnalyzers procedure to see what options are available. And 'eventually_consistent' which can be set to 'true' to make this index eventually consistent, such that updates from committing transactions are applied in a background thread.

Signature

db.index.fulltext.createNodeIndex(indexName :: STRING?, labels :: LIST? OF STRING?, properties :: LIST? OF STRING?, config = {} :: MAP?) :: VOID

Mode

SCHEMA

Table 15. db.index.fulltext.createRelationshipIndex() Deprecated

Description

Create a relationship full-text index for the given relationship types and properties.

The optional 'config' map parameter can be used to supply settings to the index. Supported settings are 'analyzer', for specifying what analyzer to use when indexing and querying. Use the db.index.fulltext.listAvailableAnalyzers procedure to see what options are available. And 'eventually_consistent' which can be set to 'true' to make this index eventually consistent, such that updates from committing transactions are applied in a background thread.

Signature

db.index.fulltext.createRelationshipIndex(indexName :: STRING?, relationshipTypes :: LIST? OF STRING?, properties :: LIST? OF STRING?, config = {} :: MAP?) :: VOID

Mode

SCHEMA

Table 16. db.index.fulltext.drop() Deprecated

Description

Drop the specified index.

Signature

db.index.fulltext.drop(indexName :: STRING?) :: VOID

Mode

SCHEMA

Table 17. db.index.fulltext.listAvailableAnalyzers()

Description

List the available analyzers that the full-text indexes can be configured with.

Signature

db.index.fulltext.listAvailableAnalyzers() :: (analyzer :: STRING?, description :: STRING?, stopwords :: LIST? OF STRING?)

Mode

READ

Table 18. db.index.fulltext.queryNodes()

Description

Query the given full-text index.

Returns the matching nodes, and their Lucene query score, ordered by score.

Valid keys for the options map are: 'skip' to skip the top N results; 'limit' to limit the number of results returned.

Signature

db.index.fulltext.queryNodes(indexName :: STRING?, queryString :: STRING?, options = {} :: MAP?) :: (node :: NODE?, score :: FLOAT?)

Mode

READ

Table 19. db.index.fulltext.queryRelationships()

Description

Query the given full-text index.

Returns the matching relationships, and their Lucene query score, ordered by score.

Valid keys for the options map are: 'skip' to skip the top N results; 'limit' to limit the number of results returned.

Signature

db.index.fulltext.queryRelationships(indexName :: STRING?, queryString :: STRING?, options = {} :: MAP?) :: (relationship :: RELATIONSHIP?, score :: FLOAT?)

Mode

READ

Table 20. db.indexDetails() Deprecated

Description

Detailed description of specific index.

Signature

db.indexDetails(indexName :: STRING?) :: (id :: INTEGER?, name :: STRING?, state :: STRING?, populationPercent :: FLOAT?, uniqueness :: STRING?, type :: STRING?, entityType :: STRING?, labelsOrTypes :: LIST? OF STRING?, properties :: LIST? OF STRING?, provider :: STRING?, indexConfig :: MAP?, failureMessage :: STRING?)

Mode

READ

Table 21. db.indexes() Deprecated

Description

List all indexes in the database.

Signature

db.indexes() :: (id :: INTEGER?, name :: STRING?, state :: STRING?, populationPercent :: FLOAT?, uniqueness :: STRING?, type :: STRING?, entityType :: STRING?, labelsOrTypes :: LIST? OF STRING?, properties :: LIST? OF STRING?, provider :: STRING?)

Mode

READ

Table 22. db.info()

Description

Provides information regarding the database.

Signature

db.info() :: (id :: STRING?, name :: STRING?, creationDate :: STRING?)

Mode

READ

Table 23. db.labels()

Description

List all available labels in the database.

Signature

db.labels() :: (label :: STRING?)

Mode

READ

Table 24. db.listLocks() Enterprise Edition

Description

List all locks at this database.

Signature

db.listLocks() :: (mode :: STRING?, resourceType :: STRING?, resourceId :: INTEGER?, transactionId :: STRING?)

Mode

DBMS

Table 25. db.ping()

Description

This procedure can be used by client side tooling to test whether they are correctly connected to a database. The procedure is available in all databases and always returns true. A faulty connection can be detected by not being able to call this procedure.

Signature

db.ping() :: (success :: BOOLEAN?)

Mode

READ

Table 26. db.prepareForReplanning()

Description

Triggers an index resample and waits for it to complete, and after that clears query caches. After this procedure has finished queries will be planned using the latest database statistics.

Signature

db.prepareForReplanning(timeOutSeconds = 300 :: INTEGER?) :: VOID

Mode

READ

Table 27. db.propertyKeys()

Description

List all property keys in the database.

Signature

db.propertyKeys() :: (propertyKey :: STRING?)

Mode

READ

Table 28. db.relationshipTypes()

Description

List all available relationship types in the database.

Signature

db.relationshipTypes() :: (relationshipType :: STRING?)

Mode

READ

Table 29. db.resampleIndex()

Description

Schedule resampling of an index.

Example: CALL db.resampleIndex("MyIndex")

Signature

db.resampleIndex(indexName :: STRING?) :: VOID

Mode

READ

Table 30. db.resampleOutdatedIndexes()

Description

Schedule resampling of all outdated indexes.

Signature

db.resampleOutdatedIndexes() :: VOID

Mode

READ

Table 31. db.schema.nodeTypeProperties()

Description

Show the derived property schema of the nodes in tabular form.

Signature

db.schema.nodeTypeProperties() :: (nodeType :: STRING?, nodeLabels :: LIST? OF STRING?, propertyName :: STRING?, propertyTypes :: LIST? OF STRING?, mandatory :: BOOLEAN?)

Mode

READ

Table 32. db.schema.relTypeProperties()

Description

Show the derived property schema of the relationships in tabular form.

Signature

db.schema.relTypeProperties() :: (relType :: STRING?, propertyName :: STRING?, propertyTypes :: LIST? OF STRING?, mandatory :: BOOLEAN?)

Mode

READ

Table 33. db.schema.visualization()

Description

Visualize the schema of the data.

Signature

db.schema.visualization() :: (nodes :: LIST? OF NODE?, relationships :: LIST? OF RELATIONSHIP?)

Mode

READ

Table 34. db.schemaStatements() Deprecated

Description

List all statements for creating and dropping existing indexes and constraints. Note that only index types introduced before Neo4j 4.3 are included.

Signature

db.schemaStatements() :: (name :: STRING?, type :: STRING?, createStatement :: STRING?, dropStatement :: STRING?)

Mode

READ

Table 35. db.stats.clear()

Description

Clear collected data of a given data section.

Valid sections are 'QUERIES'

Signature

db.stats.clear(section :: STRING?) :: (section :: STRING?, success :: BOOLEAN?, message :: STRING?)

Mode

READ

Table 36. db.stats.collect()

Description

Start data collection of a given data section.

Valid sections are 'QUERIES'

Signature

db.stats.collect(section :: STRING?, config = {} :: MAP?) :: (section :: STRING?, success :: BOOLEAN?, message :: STRING?)

Mode

READ

Table 37. db.stats.retrieve()

Description

Retrieve statistical data about the current database.

Valid sections are 'GRAPH COUNTS', 'TOKENS', 'QUERIES', 'META'

Signature

db.stats.retrieve(section :: STRING?, config = {} :: MAP?) :: (section :: STRING?, data :: MAP?)

Mode

READ

Table 38. db.stats.retrieveAllAnonymized()

Description

Retrieve all available statistical data about the current database, in an anonymized form.

Signature

db.stats.retrieveAllAnonymized(graphToken :: STRING?, config = {} :: MAP?) :: (section :: STRING?, data :: MAP?)

Mode

READ

Table 39. db.stats.status()

Description

Retrieve the status of all available collector daemons, for this database.

Signature

db.stats.status() :: (section :: STRING?, status :: STRING?, data :: MAP?)

Mode

READ

Table 40. db.stats.stop()

Description

Stop data collection of a given data section.

Valid sections are 'QUERIES'

Signature

db.stats.stop(section :: STRING?) :: (section :: STRING?, success :: BOOLEAN?, message :: STRING?)

Mode

READ

Table 41. dbms.cluster.routing.getRoutingTable()

Description

Returns endpoints of this instance.

Signature

dbms.cluster.routing.getRoutingTable(context :: MAP?, database = null :: STRING?) :: (ttl :: INTEGER?, servers :: LIST? OF MAP?)

Mode

DBMS

Table 42. dbms.cluster.overview() Enterprise Edition

Description

Overview of all currently accessible cluster members, their databases and roles.

Signature

dbms.cluster.overview() :: (id :: STRING?, addresses :: LIST? OF STRING?, databases :: MAP?, groups :: LIST? OF STRING?)

Mode

READ

Table 43. dbms.cluster.protocols() Enterprise Edition

Description

Overview of installed protocols.

Note that this can only be executed on a cluster core member.

Signature

dbms.cluster.protocols() :: (orientation :: STRING?, remoteAddress :: STRING?, applicationProtocol :: STRING?, applicationProtocolVersion :: INTEGER?, modifierProtocols :: STRING?)

Mode

READ

Table 44. dbms.cluster.quarantineDatabase() Enterprise Edition

Description

Place a database in quarantine or remove thereof.

Signature

dbms.cluster.quarantineDatabase(databaseName :: STRING?, setStatus :: BOOLEAN?, reason = No reason given :: STRING?) :: (databaseName :: STRING?, quarantined :: BOOLEAN?, result :: STRING?)

Mode

DBMS

Table 45. dbms.cluster.readReplicaToggle() Enterprise Edition

Description

The toggle can pause or resume the pulling of new transactions for a specific database. If paused, the Read Replica does not pull new transactions from the other cluster members for the specific database. The Read Replica is still available for reads, you can perform a backup, etc.

What is it for?

You can perform a point in time backup, as the backup will contain only the transactions up to the point where the transaction pulling was paused.

  1. Connect directly to the Read Replica cluster member. (Neo4j Driver use bolt:// or use the HTTP API).

  2. Pause transaction pulling for the specified database.

  3. Create a point in time backup, see Back up an online database.

If connected directly to a Read Replica, Data Scientists can execute analysis on a specific database that is paused, the data will not unexpectedly change while performing the analysis.

This procedure can only be executed on a Read Replica cluster member.

Pause transaction pulling for database neo4j
CALL dbms.cluster.readReplicaToggle("neo4j", true)
Resume transaction pulling for database neo4j
CALL dbms.cluster.readReplicaToggle("neo4j", false)

Signature

dbms.cluster.readReplicaToggle(databaseName :: STRING?, pause :: BOOLEAN?) :: (state :: STRING?)

Mode

READ

Table 46. dbms.cluster.role() Enterprise Edition

Description

The role of this instance in the cluster for the specified database.

Signature

dbms.cluster.role(database :: STRING?) :: (role :: STRING?)

Mode

READ

Table 47. dbms.cluster.setDefaultDatabase() Enterprise Edition

Description

Change the default database to the provided value.

The database must exist and the old default database must be stopped.

For more information see Change the default database.

Note that this can only be executed on a cluster core member.

Signature

dbms.cluster.setDefaultDatabase(databaseName :: STRING?) :: (result :: STRING?)

Mode

WRITE

Table 48. dbms.components()

Description

List DBMS components and their versions.

Signature

dbms.components() :: (name :: STRING?, versions :: LIST? OF STRING?, edition :: STRING?)

Mode

DBMS

Table 49. dbms.database.state()

Description

The actual status of the database with the provided name on this neo4j instance.

Signature

dbms.database.state(databaseName :: STRING?) :: (role :: STRING?, address :: STRING?, status :: STRING?, error :: STRING?)

Mode

DBMS

Table 50. dbms.functions() Deprecated

Description

List all functions in the DBMS.

Signature

dbms.functions() :: (name :: STRING?, signature :: STRING?, category :: STRING?, description :: STRING?, aggregating :: BOOLEAN?, defaultBuiltInRoles :: LIST? OF STRING?)

Mode

DBMS

Table 51. dbms.info()

Description

Provides information regarding the DBMS.

Signature

dbms.info() :: (id :: STRING?, name :: STRING?, creationDate :: STRING?)

Mode

DBMS

Table 52. dbms.killConnection()

Description

Kill network connection with the given connection id.

Signature

dbms.killConnection(id :: STRING?) :: (connectionId :: STRING?, username :: STRING?, message :: STRING?)

Mode

DBMS

Table 53. dbms.killConnections()

Description

Kill all network connections with the given connection ids.

Signature

dbms.killConnections(ids :: LIST? OF STRING?) :: (connectionId :: STRING?, username :: STRING?, message :: STRING?)

Mode

DBMS

Table 54. dbms.killQueries()

Description

Kill all transactions executing a query with any of the given query ids.

Signature

dbms.killQueries(ids :: LIST? OF STRING?) :: (queryId :: STRING?, username :: STRING?, message :: STRING?)

Mode

DBMS

Table 55. dbms.killQuery()

Description

Kill all transactions executing the query with the given query id.

Signature

dbms.killQuery(id :: STRING?) :: (queryId :: STRING?, username :: STRING?, message :: STRING?)

Mode

DBMS

Table 56. dbms.killTransaction()

Description

Kill transaction with provided id.

Signature

dbms.killTransaction(id :: STRING?) :: (transactionId :: STRING?, username :: STRING?, message :: STRING?)

Mode

DBMS

Table 57. dbms.killTransactions()

Description

Kill transactions with provided ids.

Signature

dbms.killTransactions(ids :: LIST? OF STRING?) :: (transactionId :: STRING?, username :: STRING?, message :: STRING?)

Mode

DBMS

Table 58. dbms.listActiveLocks() Enterprise Edition

Description

List the active lock requests granted for the transaction executing the query with the given query id.

Signature

dbms.listActiveLocks(queryId :: STRING?) :: (mode :: STRING?, resourceType :: STRING?, resourceId :: INTEGER?)

Mode

DBMS

Table 59. dbms.listConfig()

Description

List the currently active config of Neo4j.

Signature

dbms.listConfig(searchString = :: STRING?) :: (name :: STRING?, description :: STRING?, value :: STRING?, dynamic :: BOOLEAN?)

Mode

DBMS

Table 60. dbms.listConnections()

Description

List all accepted network connections at this instance that are visible to the user.

Signature

dbms.listConnections() :: (connectionId :: STRING?, connectTime :: STRING?, connector :: STRING?, username :: STRING?, userAgent :: STRING?, serverAddress :: STRING?, clientAddress :: STRING?)

Mode

DBMS

Table 61. dbms.listPools() Enterprise Edition

Description

List all memory pools, including sub pools, currently registered at this instance that are visible to the user.

Signature

dbms.listPools() :: (pool :: STRING?, databaseName :: STRING?, heapMemoryUsed :: STRING?, heapMemoryUsedBytes :: STRING?, nativeMemoryUsed :: STRING?, nativeMemoryUsedBytes :: STRING?, freeMemory :: STRING?, freeMemoryBytes :: STRING?, totalPoolMemory :: STRING?, totalPoolMemoryBytes :: STRING?)

Mode

DBMS

Table 62. dbms.listQueries()

Description

List all queries currently executing at this instance that are visible to the user.

Signature

dbms.listQueries() :: (queryId :: STRING?, username :: STRING?, metaData :: MAP?, query :: STRING?, parameters :: MAP?, planner :: STRING?, runtime :: STRING?, indexes :: LIST? OF MAP?, startTime :: STRING?, protocol :: STRING?, clientAddress :: STRING?, requestUri :: STRING?, status :: STRING?, resourceInformation :: MAP?, activeLockCount :: INTEGER?, elapsedTimeMillis :: INTEGER?, cpuTimeMillis :: INTEGER?, waitTimeMillis :: INTEGER?, idleTimeMillis :: INTEGER?, allocatedBytes :: INTEGER?, pageHits :: INTEGER?, pageFaults :: INTEGER?, connectionId :: STRING?, database :: STRING?)

Mode

DBMS

Table 63. dbms.listTransactions()

Description

List all transactions currently executing at this instance that are visible to the user.

Signature

dbms.listTransactions() :: (transactionId :: STRING?, username :: STRING?, metaData :: MAP?, startTime :: STRING?, protocol :: STRING?, clientAddress :: STRING?, requestUri :: STRING?, currentQueryId :: STRING?, currentQuery :: STRING?, activeLockCount :: INTEGER?, status :: STRING?, resourceInformation :: MAP?, elapsedTimeMillis :: INTEGER?, cpuTimeMillis :: INTEGER?, waitTimeMillis :: INTEGER?, idleTimeMillis :: INTEGER?, allocatedBytes :: INTEGER?, allocatedDirectBytes :: INTEGER?, pageHits :: INTEGER?, pageFaults :: INTEGER?, connectionId :: STRING?, initializationStackTrace :: STRING?, database :: STRING?, estimatedUsedHeapMemory :: INTEGER?)

Mode

DBMS

Table 64. dbms.procedures() Deprecated

Description

List all procedures in the DBMS.

Signature

dbms.procedures() :: (name :: STRING?, signature :: STRING?, description :: STRING?, mode :: STRING?, defaultBuiltInRoles :: LIST? OF STRING?, worksOnSystem :: BOOLEAN?)

Mode

DBMS

Table 65. dbms.quarantineDatabase

Description

Place a database in quarantine or remove thereof.

Signature

dbms.quarantineDatabase(databaseName :: STRING?, setStatus :: BOOLEAN?, reason = No reason given :: STRING?) :: (databaseName :: STRING?, quarantined :: BOOLEAN?, result :: STRING?)

Mode

DBMS

Table 66. dbms.queryJmx()

Description

Query JMX management data by domain and name.

Valid queries should use the syntax outlined in the javax.management.ObjectName API documentation.
For instance, use "*:*" to find all JMX beans.

Signature

dbms.queryJmx(query :: STRING?) :: (name :: STRING?, description :: STRING?, attributes :: MAP?)

Mode

DBMS

Table 67. dbms.routing.getRoutingTable()

Description

Returns endpoints of this instance.

Signature

dbms.routing.getRoutingTable(context :: MAP?, database = null :: STRING?) :: (ttl :: INTEGER?, servers :: LIST? OF MAP?)

Mode

DBMS

Table 68. dbms.scheduler.failedJobs() Enterprise Edition

Description

List failed job runs. There is a limit for amount of historical data.

Signature

dbms.scheduler.failedJobs() :: (jobId :: STRING?, group :: STRING?, database :: STRING?, submitter :: STRING?, description :: STRING?, type :: STRING?, submitted :: STRING?, executionStart :: STRING?, failureTime :: STRING?, failureDescription :: STRING?)

Mode

DBMS

Table 69. dbms.scheduler.groups() Enterprise Edition

Description

List the job groups that are active in the database internal job scheduler.

Signature

dbms.scheduler.groups() :: (group :: STRING?, threads :: INTEGER?)

Mode

DBMS

Table 70. dbms.scheduler.jobs() Enterprise Edition

Description

List all jobs that are active in the database internal job scheduler.

Signature

dbms.scheduler.jobs() :: (jobId :: STRING?, group :: STRING?, submitted :: STRING?, database :: STRING?, submitter :: STRING?, description :: STRING?, type :: STRING?, scheduledAt :: STRING?, period :: STRING?, state :: STRING?, currentStateDescription :: STRING?)

Mode

DBMS

Table 71. dbms.scheduler.profile() Enterprise Edition

Description

Begin profiling all threads within the given job group, for the specified duration.

Note that profiling incurs overhead to a system, and will slow it down.

Signature

dbms.scheduler.profile(method :: STRING?, group :: STRING?, duration :: STRING?) :: (profile :: STRING?)

Mode

DBMS

Table 72. dbms.security.activateUser() Enterprise Edition Deprecated

Description

Activate a suspended user.

Signature

dbms.security.activateUser(username :: STRING?, requirePasswordChange = true :: BOOLEAN?) :: VOID

Mode

WRITE

Table 73. dbms.security.addRoleToUser() Enterprise Edition Deprecated

Description

Assign a role to the user.

Signature

dbms.security.addRoleToUser(roleName :: STRING?, username :: STRING?) :: VOID

Mode

WRITE

Table 74. dbms.security.changePassword() Deprecated

Description

Change the current user’s password.

Signature

dbms.security.changePassword(password :: STRING?, requirePasswordChange = false :: BOOLEAN?) :: VOID

Mode

WRITE

Table 75. dbms.security.changeUserPassword() Enterprise Edition Deprecated

Description

Change the given user’s password.

Signature

dbms.security.changeUserPassword(username :: STRING?, newPassword :: STRING?, requirePasswordChange = true :: BOOLEAN?) :: VOID

Mode

WRITE

Table 76. dbms.security.clearAuthCache() Enterprise Edition

Description

Clears authentication and authorization cache.

Signature

dbms.security.clearAuthCache() :: VOID

Mode

DBMS

Table 77. dbms.security.createRole() Enterprise Edition Deprecated

Description

Create a new role.

Signature

dbms.security.createRole(roleName :: STRING?) :: VOID

Mode

WRITE

Table 78. dbms.security.createUser() Deprecated

Description

Create a new user.

Signature

dbms.security.createUser(username :: STRING?, password :: STRING?, requirePasswordChange = true :: BOOLEAN?) :: VOID

Mode

WRITE

Table 79. dbms.security.deleteRole() Enterprise Edition Deprecated

Description

Delete the specified role. Any role assignments will be removed.

Signature

dbms.security.deleteRole(roleName :: STRING?) :: VOID

Mode

WRITE

Table 80. dbms.security.deleteUser() Deprecated

Description

Delete the specified user.

Signature

dbms.security.deleteUser(username :: STRING?) :: VOID

Mode

WRITE

Table 81. dbms.security.listRoles() Enterprise Edition Deprecated

Description

List all available roles.

Signature

dbms.security.listRoles() :: (role :: STRING?, users :: LIST? OF STRING?)

Mode

READ

Table 82. dbms.security.listRolesForUser() Enterprise Edition Deprecated

Description

List all roles assigned to the specified user.

Signature

dbms.security.listRolesForUser(username :: STRING?) :: (value :: STRING?)

Mode

READ

Table 83. dbms.security.listUsers() Deprecated

Description

List all native users.

Signature

dbms.security.listUsers() :: (username :: STRING?, roles :: LIST? OF STRING?, flags :: LIST? OF STRING?)

Mode

READ

Table 84. dbms.security.listUsersForRole() Enterprise Edition Deprecated

Description

List all users currently assigned the specified role.

Signature

dbms.security.listUsersForRole(roleName :: STRING?) :: (value :: STRING?)

Mode

READ

Table 85. dbms.security.removeRoleFromUser() Enterprise Edition Deprecated

Description

Unassign a role from the user.

Signature

dbms.security.removeRoleFromUser(roleName :: STRING?, username :: STRING?) :: VOID

Mode

WRITE

Table 86. dbms.security.suspendUser() Enterprise Edition Deprecated

Description

Suspend the specified user.

Signature

dbms.security.suspendUser(username :: STRING?) :: VOID

Mode

WRITE

Table 87. dbms.setConfigValue() Enterprise Edition

Description

Update a given setting value. Passing an empty value results in removing the configured value and falling back to the default value. Changes do not persist and are lost if the server is restarted. In a clustered environment, dbms.setConfigValue affects only the cluster member it is run against.

Signature

dbms.setConfigValue(setting :: STRING?, value :: STRING?) :: VOID

Mode

DBMS

Table 88. dbms.showCurrentUser() Deprecated

Description

Show the current user.

Signature

dbms.showCurrentUser() :: (username :: STRING?, roles :: LIST? OF STRING?, flags :: LIST? OF STRING?)

Mode

DBMS

Table 89. dbms.upgrade()

Description

Upgrade the system database schema if it is not the current schema.

Signature

dbms.upgrade() :: (status :: STRING?, upgradeResult :: STRING?)

Mode

WRITE

Table 90. dbms.upgradeStatus()

Description

Report the current status of the system database sub-graph schema.

Signature

dbms.upgradeStatus() :: (status :: STRING?, description :: STRING?, resolution :: STRING?)

Mode

READ

Table 91. tx.getMetaData()

Description

Provides attached transaction metadata.

Signature

tx.getMetaData() :: (metadata :: MAP?)

Mode

DBMS

Table 92. tx.setMetaData()

Description

Attaches a map of data to the transaction. The data will be printed when listing queries, and inserted into the query log.

Signature

tx.setMetaData(data :: MAP?) :: VOID

Mode

DBMS